How to include and exclude staff names in queries?

Harrold

Registered User.
Local time
Tomorrow, 06:22
Joined
Mar 17, 2011
Messages
72
Hi,

say, i have a list of staff bank account number and
1) i want it be shown in query except for one person. How to set a criteria for this?
2) i only want to show one person and the rest not to shown. How to set a criteria for this?

Thanks
 
1: <> "Johnson"
2: ="Johnson"

JR
 

Users who are viewing this thread

Back
Top Bottom