Parameter values

[richary]

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

 

[roelandkim]

In the criteria of the query put something like:

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

Or just this:

Not [Enter Parameter]

 

[jfgambit]

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

 

[richary]

Thanks for replies. I'll try that!