Ciao,I have a little problem with a view.
In a form users insert data about workin hours and other like holidays, illness…
Then, I want that view shows in each column (1 column for each day of the week) the hours (working or not) and type of cause (for example holiday, overtime, illness etc.)
This is the formula:
C01 := @Text (Ore07);
C01_1 := @Text (HG7);
C01_2 := @Text (HG07_1);
C01_3 := @Text (HG07_2);
C01 + " " + " " + C01_1 + " " + @Left(G7;3) + " " + C01_2 + " " + @Left(G7_1;3) + " " + C01_3 + " " + @Left(G7_2;3)
Where Ore07, HG7, HG7_1 and HG7_2 are hours (number) and G7, G7_1 and G7_2 are text (cause)
With this formula column shows all the text, if aren’empty fields, but not HG07_1 and HG07_2. If I change position (HG07_2 instead of HG7) it shows the value of HG07_2. But as the example, doesn’t show the last two values.
Is a problem of too many field to add up? Unfortunately I’ve to see all the fields, if filled.
Many thanks (I hope I describe clearly my doubt).
Ciao
Nicola