Thanks for the reply Teddy. I tried to implement what you had said, I had thought of this before but wasnt sure if I did it right, but the problem with that statement is after I select combobox1 the data shows up correctly, but when I select combobox2 the data is still the same as when I selected combobox 1 alone. And it is the same when I select all 3 comboboxes...access doesnt seem to have the intelligence to figure out that if I have 2 comboboxes selected that I want the query to show the results for the criteria of combobox1 AND combobox2, instead it keeps querying the combobox1 statement alone and outputting the result. Do you have any other suggestions?
"You can lead a horse to water, but you cant teach him how to drink"
I appreciate the suggestions and feedback from everyone here...but either I dont know how to drink and need to be taught, or I am just 3/4 of the way there and just need that other quarter to get over the top. I could make a test case for someone to help explain a solution to me, or maybe to better explain my problem. I am fairly new to access, and I am learning as I go along. When you say make a function and call it in your query, I dont know where to begin, although I dont see how its a lot different from trying to do it through a straight sql statement. In a similar note, is there any good websites for learning relatively things that are relatively advanced? Every time I search for a tutorial on the internet I come up with websites that teach you "how to create a table, how to use the query wizard" etc and I feel my lack of knowledge to be a burden to people on here, like I am asking too stupid questions. I will post a test case this evening after I have done reformatting my home computer because windows sucks ...I am making the transition to linux, still keeping a windows partition, but I wont have access to access until after I am done. Thanks for all your help guys, if anyone can in the meantime post an explanation to this problem that a small child would understand I would be very greatful.