Parameter Query for two different fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:];
 
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"
 
Back
Top