Parameter values

richary

Registered User.
Local time
Today, 21:38
Joined
May 26, 2004
Messages
167
I would like to use the access enter parameter value dialog to return records where the field is NOT equal to the paramter value. So, for example I would like to return all pupils whose name is not "Smith".

Is this possible? I've tried entering directly into the dialog, but get an error.

Thanks
Richar y
 
In the criteria of the query put something like:

Not Like "*" & [Enter Parameter] & "*"

Or just this:

Not [Enter Parameter]
 
Assuming you are using a query, you can add the following to the Criteria of the name field:

<>[All students except?]

When you run the query, you will get the dialog box that asks the following "All Students except?", if you type "Smith" you will get all students who's last names are not "Smith"

HTH
 

Users who are viewing this thread

Back
Top Bottom