Search results

  1. A

    IIf Date Query Issue

    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...
  2. A

    #error when running Access query

    Hello, I don't know if there is a thread already on this, apologies if there is. I'm running a query and I'm trying to order it based on a number of IIf statements. However, I'm running into #error for the final IIf statement. I can post the SQL view, but can't send the database due to...
Top Bottom