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

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
 
R

Rick Brandt

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?
 
L

Lord Kelvan

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
 
Top