Hi all,
I posted on another website, but IT suggested posting on this site. I apologize for the cross-post, but I am approaching a deadline, and the pressure is on.
I am having trouble in Access 2010 getting an IIF function to work.
I have 4 text boxes that show on a report; [BilledHours](standard format), [IssueHours](standard format), [Hour%](percentage format), and [HourDiff](standard format).
This takes place in an invoice footer. I am trying to make it so that the [HourDiff] box shows a 0 only if the [Hour%] is less than 5, but execute a formula if the [Hour%] is over 5. The report shows multiple invoices, and there is only 1 invoice that needs the IIF to work.
I am using
"=IIF([Hour%]<=5,0,[BilledHours]-[IssueHours])"
When I run the report, nothing changes, but when I change it to greater than, the boxes all change to 0.
Thanks in Advance,
John M.