K kylepanek New member Local time Today, 17:47 Joined Sep 17, 2008 Messages 8 Sep 17, 2008 #1 I have a form set up to search by field. But if i have more than one critera my query doesn't find anything.
I have a form set up to search by field. But if i have more than one critera my query doesn't find anything.
khawar AWF VIP Local time Tomorrow, 03:47 Joined Oct 28, 2006 Messages 870 Sep 17, 2008 #2 you can add as many "or" as you want in the query grid
K kylepanek New member Local time Today, 17:47 Joined Sep 17, 2008 Messages 8 Sep 17, 2008 #3 I understand how to use an "or" in a single field.... I want to use a or amongst several fields if that make sense.
I understand how to use an "or" in a single field.... I want to use a or amongst several fields if that make sense.
khawar AWF VIP Local time Tomorrow, 03:47 Joined Oct 28, 2006 Messages 870 Sep 17, 2008 #4 upload a sample if possible i will do it
K kylepanek New member Local time Today, 17:47 Joined Sep 17, 2008 Messages 8 Sep 17, 2008 #5 here you go Attachments help.zip help.zip 111.7 KB · Views: 105
khawar AWF VIP Local time Tomorrow, 03:47 Joined Oct 28, 2006 Messages 870 Sep 17, 2008 #6 Download the sample you can search on name and ranumber through a single field on form Attachments test.zip test.zip 19.7 KB · Views: 115