Search results

  1. C

    Syntax error: missing operator in query expression

    Not hard to do! Thanks all for the help; and ByteMyzer, with a few tweaks to the date fields I was able to get the code you pasted to work PERFECTLY! Thanks again, cmarucco.
  2. C

    Syntax error: missing operator in query expression

  3. C

    Syntax error: missing operator in query expression

    Thanks ByteMyzer! I'll try it out...And read up on the Switch command!
  4. C

    Syntax error: missing operator in query expression

    Basically... I have a table 'Items' that contains many variables, two of which are 'Code' and 'Date_of_Service'. I have four tables that contain corresponding 'codes' and a 'payment rate' for each. The four tables are broken into 3-month segments: Jan-Mar, April-June, July-Sept...
  5. C

    Syntax error: missing operator in query expression

    Does anyone see the problem in the syntax below?!? (Other than an overly complicated IIF statement that should be approached a bit differently)...but I'm not a very advanced user. SELECT Inpatient_Item_Level.Patient_Account_Number, Inpatient_Item_Level.ID, IIF([Date_of_Service] BETWEEN...
Back
Top Bottom