I don't have a solution for you but you are obviously overwhelming Access with your query. You may simply have to simplify thing a bit to get it to work.
I don't have a solution for you but you are obviously overwhelming Access with your query. You may simply have to simplify thing a bit to get it to work.
Okay thanks, Offie said the criteria I was using was wrong. I'm guessing what I wrote in the criteria was too complex or didn't make sense. Do you know the correct criteria I should use to make it so that if a field is left blank then nothing returns, if you enter information into a field results will return that are exactly the same or contain what you put into the field. For example if you put 'John' into full name and left 'Age' blank then results will return with 'John' and 'Johnathan' with any age. basically like a normal search engine. I think I need to use 'LIKE' in the criteria.
Thanks
How do you want them to show up?
Ex:
Age: 18
Name: Bob
1: Show all age 18 and all name Bob
2: Show All 18 year olds who are named Bob.
Why do you want it to be blank if eveything is blank? Usually you get everything then then set parameters to narrow down what you have.
I want the second one. Show All 18 year olds who are named Bob. Yeah I do mean everything but the parameters narrow it down. Maybe I didn't explain my self well enough.
Thanks
Not sure what you're up to right now with all the message confusion going on, but try the like with the "*"
A good tool is this video, pretty simple stuff but you can see everything.
http://www.youtube.com/watch?v=CTiA_4Me0cI
As a base: Like "*" & Forms!... & "*"
What this does is default shows eveything (when the textbox is blank) but when the text box has something in it it will show [Everything][Specified][Everything]
So if you type in "may" things that will show up will include "mayday" "end of may" and so on. If want only to start with Forms!... then get rid of the first "*" &
If you type in the format for all of your fields:
Ex: Age, Name, Job
>If you leave it blank then everything will show up
>If you enter 18 as the age then all records that have an age of 18 will show up
>If you enter 18 and Bob then all records that have both 18 and Bob will show up
>Same including Job
>If you enter only Doctor as the Job then all the rows with Doctors will show up.
This is what you messaged me earlier and it is exactly what I want, thank you