I keep getting the following error on my query: Syntax error (comma) in query expression 'Invoice_Header.[IIf([Document_Date]<5/1/2018,"1%","2%")'.
This is my query: Rate: IIf([Document_Date]<5/1/2018,"1%","2%")
If I take out the table field: Invoice_Header, the query goes through, but it marks everything as 2% even though I know that there are records going back to before May 1, 2018 that should be 1%.
Any help would be appreciated.