Search results

  1. A

    IIF Statement in a Select Query, Access 2003

    Hello, I know this will probably be a quick question for someone with good knowledge with Access Query's. I am trying to make a query that will calculate fields like this-- Expr1: IF ([Job Type]="Audit" OR "AuditNTX" THEN [PropAudit]-[Discount Amount]) ELSE IF ([Job Type="Review" OR...
  2. A

    Date formatting issue Access 2003

    Hello, I am having an issue where I am trying to make a date in a certain field not contain the weekday. I am running a query and I will need to select from a period of time from 1/1/08-12/31/09. I am wondering how I can remove the weekday from the date. The format for long date currently...
Back
Top Bottom