I have a field in a table called Production Transition. The record in that field is either a date (1-1-19) or the letters NA or the word Currently. When I set up my query for this field I set the criteria for this field as Not "NA" and Not "Currently" as I don't want those to appear in the resulting spreadsheet. When I run the query all is good and only the dates remain. However, when I try to sort the remaining dates I am told:
"Syntax error (missing operator) in query expression "Production Transition'.
Have played with this for hours and can't figure out what the heck the issue is!