Hello ,
i have posted a couple of days ago for some other issues but i have ( eventually ) solve it .
After many thoughts as i cant automaticly make a query in the same table to calculate the remaining annual leave , as the SUM function that i need i am already using it for other fields in the query and that querys now is a report that automaticly calculate the employee names , and the sum of their leave types that they have .
A thought that came on my mind is to calcualte the remaining annual leave via the expression builder.
Therefore i did it and it works correctly BUT , as i havent been experiment much of my time to expression builder i have a small issue ( i hope ) .
I ve made a new textfield and have control source the following: =[Licenses]-([Annual]+[Personal])
Licenses is the initial License that each employe has.
Annual is the SUM of the annual leave that employee has.
Personal is the SUM of the annual leave that employee has.
Some employees have only annual licenses and not (still) any personal
The specific expressions calculates ONLY the employee that has Annual AND Personal .
So i want to modify to calculate Annual OR Personal and i need both calculation to be together, not, license - annual OR license - Personal .
Another thing that i should mention is that the fields and specificaly the employees that they do not have any Personal annual leave , their field is NULL and not a zero 0 , i hope thats not the problem .
Thats all