I have a query that works but need to add an additional criteria on [ContractAmt].
I am not sure why I get the error message as it is below.
I can design a separate query with the same criteria on [ContractAmt] and dont get the error but I dont have all the additional criteria (the Cdate).
If it matters, the Cdate formula is = Between CDate(Date()-30) And CDate(Date()+30)
[ContractAmt] ppty = Currency, Standard
Let me know what you think could be the issue.