Re: Query by Combo Box / Query by Form Controls

[mimottershaw]

Re: Query by Combo Box / Query by Form Controls

Hi Adam,

Thanks very much for your assistance. I'm relieved I'm not the only one to have got stuck with this issue. Unfortunately my knowledge of Access is pretty much limited to built in functions and applications, and I really start to struggle with SQL queries. My Query is several fields taken from a table, and I'm using a built in query. Do you know of a way, function, command or syntax that I can enter in each criteria field to either return specific records, or all records if each field is empty? I enter all of my criteria on a form at once rather than step by step as in your example, and I'm afraid I'm not up to the job converting it.

I'm sorry I am unable to understand you advice, and I'd be really grateful if you could help me with a solution that can be entered in a criteria box of several fields in a built-in query.

Thanks again,

Mark.