a simple one! please help! :D

[RDM]

this is my query in design view



i use this query when entering data

i want to know how i can set it up it display all or any one/two/none of the criteria i put into the question text boxes, number surname and state, or even just number, or just state.

anyone?

 

[EMP]

You can use a form for the user to fill in only the criteria needed.

See Jon K's query criteria in this example:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^