Filter out 'Fail'

YouMust

Registered User.
Local time
Today, 05:27
Joined
May 4, 2016
Messages
106
I'm sure it's really simple, but I just cant seem to figure it out.

I have a load of test results that I want to filter in a qry so I only see passed results and not any failures.
I just cant seem to get it to work at all.
Here's my qry

best image hosting free

The 'Result' field is long text not sure if that makes any difference
 
Long Text or Memo fields (older versions of access) don't like being used in aggregate functions. If it only has a small amount of text then change it to a normal text field.

They can have other issues as well - http://allenbrowne.com/ser-63.html
 

Users who are viewing this thread

Back
Top Bottom