You'll all have to forgive my ignorance on this one, I am very new to this game. I have been developing a db but have written all my queries by hand as the query builder is making no sense to me. These queries are getting very long and difficult to debug so I am cracking and asking for help. Is it possible to use input from a form as criteria in the query design?? I have not seen any examples of this so am i on my own to write them?? I realize this is a broad question....sorry.

you wrote:
----------
but have written all my queries by hand as the query builder is making no sense to me.
----------

do you mean the QBE grid or the query wizard. how did you write your queries 'by hand', in SQL?

you wrote:
------
Is it possible to use input from a form as criteria in the query design?
------
Yes, and that is a very powerful tool that access provides.

provide more info please.. http://www.access-programmers.co.uk/ubb/smile.gif

al