Thanks Ken. I've had a look at this and I must admit that the SQL language is
beyond me, I'm afraid. I had expected simply to be entering criteria on the
design view of the query. Of course I can still use multiple copies of the
same queries but if there is a way to use one query but several criteria I'm
sure it would be neater.

Can you suggest another way around this? I think I need to go back to basics!


Cheers
CK

Ken Snell (MVP) wrote:
Perhaps this sample database will point you in the right direction. It shows
how to build WHERE clauses that can be used to filter forms/reports based on
selections/entries made by the user on the first form.

Building SQL string based on values entered into controls
http://www.accessmvp.com/KDSnell/Sam...htm#FilterForm

Hi

[quoted text clipped - 28 lines]
Cheers
CK1

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200901/1