Search results

  1. A

    IIf Date Query Issue

    No worries. Thanks for the help anyway.
  2. A

    IIf Date Query Issue

    For your own access amusement, here is the full sql view. It is the amount of debt(unpaid billed time) for each lawyer. PARAMETERS Run_date DateTime; SELECT dbo_DEPARTMT.DEPNAME, dbo_Staff.strStaffName...
  3. A

    IIf Date Query Issue

    Thank you everyone for the replies. I have finally fixed it anyway!:D
  4. A

    IIf Date Query Issue

    The point of the sum is, this query is to produce the total amount of debtors for each person in specific debtor periods i.e. Current month, 1 month, 2 months etc. Thus, if I was running the query for 30th September, then the query would allow me to produce the total amount of debtors for person...
  5. A

    IIf Date Query Issue

    Thank you! The error issue is now solved, it now runs.However, it produces 0 for everyone, which should not be the case. So another issue begins, which I'll attempt to solve :banghead:
  6. 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...
  7. 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