Need help with query

[poianaladra]

Basically, i have a table with about 20 fields: i want to filter the results according to the data inserted in a form,


but when the user compiles the form, he might not know some data, so some fields are empty, some aren't:

what i need is a query that shows results based only on the fields that aren't empty,

simplified example of the form that i will use to filter the results:

First name	Last name	Date of birth	Place of birth
Pippo		18/12/1993	Ovodda

Now i'd need the query to show all the records matching the three fields that have been compiled PLUS any record which field has been left empty: so, in this case, show me any record which contains Pippo in the first name field, 18/12/1993 in the DOB, Ovodda in the POB AND anything (included nothing) in the last name.
How can i do that?
Thanks in advance.

[CJ_London]

you need something like this

SELECT *
FROM myTable
WHERE [Last Name] is null or [Last Name]=forms!myform!lastnamectrl

[poianaladra]

Thanks for your reply!
That would be the VB script if i'm correct; i'd like to know what to put here, though

And thanks again!

[CJ_London]

is null or forms!myform!lastnamectrl