how can I do a parameter search for multiple fields?

[abbazabba]

Hi, I'm new to this forum and a bit of a beginner at access...Hello!

I'm creating a database for logging the hiring out of kit from our photography dept. I have created a form with 6 fields dedicated to equipment (the students can hire up to 6 bits of kit).

I need to be able to do one parameter search for all six fields...


the fields are named: ITEM1 to ITEM6.

The form is called 'equipment2' and the table is called 'equipment'...

I tried this on the SQL view and it almost seemed like it was going to work, but brought up results that didn't fit the parameters as well as the correct results:

WHERE ((([EQUIPMENT].[ITEM1].EQUIPMENT.ITEM2.EQUIPMENT.ITEM3.EQUIPMENT.ITEM4.EQUIPMENT.ITEM5.EQUIPMENT.ITEM6)=[SEARCH FOR ITEM]));

Can you see any problems with it? Is it jibberish?

Cheers!

 

[hymn]

try going to the tab(Keyword search) and do a search in there
you will find plenty of forums on that subject

Hope this helps
Hymn

 

[PadawanJoey]

Just build a Query, with your parameters as criteria.

Criteria = [Enter Name Here] [Enter State Here]

These each go in seperate fields.

HTH,

Joey