I haven't used Access for a while so I'm a bit "rusty" on query filters.
Please find attached 2 documents:
The database contains one Table and two queries. The spreadsheet mimics the value set in Table1.
In the two Access queries, I'm trying to calculate the average values for the four records BUT MUST EXCLUDE any records where value = 999.
The difference between query 1 and query 2 is where I placed the filter "< > 999" ("and" vs. "or").
The XLS provides the correct average values. That is, I've manually excluded the 999 values in the average calculation.
My question: How I can get same four average values (as shown in XLS) in an MS-Access query?