A little stummped....
I have a calculated field in a query which works 100%:
TotalDays:[EndDate]-[StartDate]
The only issue is that if the EndDate and StartDate is the same then the result is 0
I created another field which soves my problem of 0 day results:
Total_Days: IIf([TotalDays]<="0","1")
I am having difficulty conbining the two results in the IIf field. What I want to achieve is the following:
If the calculation in [TotalDays] is correct or returning the correct day count then the TotalDays must show, however if the [TotalDays] is less than or equal to 0 then display 1
Eg: if [TotalDays] is 3 then it must show 3 but if it is 0 then it must show 1