How to Create Search Form

J

Jason

I have a Table with 5 Fields. Name, City, State, Zip, Registration
Date.

I trying to design a form where I can search a date range within the
Registration Date field and search the remaining fields at the same
time. Plus I need results even is there is not a value in a paticular
field. For example, I'll do a search for State and a date range and
leave the other fields blank.

I have the form created and can search only one field at a time. I'm
sure my query criteria is way off. Any help greatly appreciated.

Jason.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top