Parameter Query for two different fields

J

jk

Hi,

I have two fields that contain a three letter code.I would like to run a
parameter query that when the user is prompted for the code.....the record
can be selected from either field.For example.......Field name Field name
Rebills Credits
Codes rsd fpr
wrd fds
The above example is how query displays the fields.Now i need to know if it
is possible for a parameter dialog box to prompt the user to enter a code so
only that record is selected.Can this be done???
Thanks
 
K

Ken Snell [MVP]

You want the user to enter a parameter and look in both fields?

SELECT TableName.*
FROM TableName
WHERE TableName.Rebills = [Enter three-letter code:]
OR TableName.Credits = [Enter three-letter code:];
 
J

Jeff Boyce

Are you saying that a given three letter code could appear in either field,
or that you want to query along the lines of:

If [State] = "Colorado" Or [City] = "Portland"
 
Top