how do I get the OR function working in query using ACCESS

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I put a name in criteria and another in OR but when i look at run query only
the first name is showing
 
frank said:
I put a name in criteria and another in OR but when i look at run
query only the first name is showing
Click to expand...

What happens when you swap them?
 
if you have other criteria you need to also put them on the or line
you could try putting

name1 or name2 on the same line in the criteria

Regards
Kelvan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Multiple Parameter Crosstab query filter by form 1
Parameter Queries in Crosstab Query 2
Can I use a number variable in a Query? 10
Can I call a function in query criteria? 4
Simple query question in MS Access 4
Multiselect listbox problem in queries 2

Back
Top