Multiple query fields of a form

[josephbupe]

Hello everyone!

I am new to MS Access. I am creating a small database for motor vehicle clearance. I have a SEARCH form where i want to put the fields for searching query table:

VEHICLE MAKE:

REF No.:

BEGIN DATE:
END DATE:

I need it in such a way that even when only one of the above fields is supplied with data it should still return correct data from the query table.

For dates (BEGIN DATE, END DATE) i tried: Between [forms]![search]![begin date] and [forms]![search]![end date]

This worked well when placed alone of the SEARCH form. But when i added more fields (VEHICLE MAKE, REF No.) the query returned nothing but a blank query table.

How can i possibly resolve this.

I will appreciated.

 

[pl456]

I found if I used too many of these in a query it started to return incorrect data.
You would be bettter using VBA to query form data entered onto the form.

Although you may be able to use the 'Like' criteria at the beginning of what you currently have.

 

[neileg]

Plenty of examples in these forums if you do a search. As pl456 says, the LIKE operator is they key to this.

 

[josephbupe]

Mulple query text boxes on a form

I found if I used too many of these in a query it started to return incorrect data.
You would be bettter using VBA to query form data entered onto the form.

Although you may be able to use the 'Like' criteria at the beginning of what you currently have.

Could you show me how to do it or point me to where i can find a tip on using the VB for this?

 

[pl456]

It can be hard to find what you need, this should help.

http://www.fontstuff.com/access/acctut17.htm

 

[EMP]

See the query in the attached sample database, which is based on Jon K's thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^