I am looking for help on a specific SQL query in MS Access. I keep running into syntax errors. I have 4 fields in the query. When the data I’m querying is LIKE the data in field 1 AND the data in field 3 and/or 4 IS NULL or BLANK, then I want the null or blank records in 3 or 4 to display the text result, “ANY”
Is there anyone out there that knows Access query?
I am used to straight SQL query via a back-end connection like TOAD, so the restrictions of MS Access have me at a road block.
