Recent content by DavidW

Pat, I will try your suggestions. Thanks very much for all your help and patience. Dave :)

Pat, I have browsed through the link that you suggested and I am somewhat lost. Obviously I have a lot to learn. I am wondering how to execute the query in code and have it populate my report properly. I have a form with a command button which calls the report and the report in turn calls...

Pat, Thanks for your post. Being a relative neophyte at programming in Access I'm not sure I understand your response. I don't understand what you mean by it being Dynamic. When I pass the string to the Global Function it is fixed. If you mean that just using an Or is defined as being...

Tony, Thanks for the response. I don't actually have the code written yet that gives me the multiple conditions for the query. I wanted to make sure that I could make the query work first before I wrote the actual code. What I have been doing to test is to create a string value in a...

I have searched through and looked at several excellent threads regarding the use of Variables from VBA as queries. Using this knowledge I have created a function that returns a string and I have put that function into a Query and it works for simple results such as when a single character...