Once again I am stuck. Basically I have a query as followed:
Current: Sum(IIf([Run_date]-[dbo_GD-AgedDebtors]![BillDate]<=30,[dbo_GD-AgedDebtors]![Outstanding],0))
I'm trying to show outstanding bills if the bill date is less than or equal to my date parameter. However, it keeps coming up "This...