F frank Sep 3, 2008 #1 I put a name in criteria and another in OR but when i look at run query only the first name is showing
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 Sep 3, 2008 #2 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?
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 Sep 3, 2008 #3 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
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
F frank Sep 4, 2008 #4 Rick Brandt said: What happens when you swap them? Only the name in the critera shows up Click to expand...
Rick Brandt said: What happens when you swap them? Only the name in the critera shows up Click to expand...