Query By Form Criteria Problem(s),,maybe AND/OR issue

F

FerryMary

Hi Again {{sheepish wave}}

Using Access 2003
Querying Maintenance Jobs

What I did:
Created Query with desired fields
Created Form based on query
In header placed 6 Unbound fields (some text some combo) which either lookup
or await input for query criteria

I used OR for the six criteria in query design. Query returns info as
expected if only 1 criteria is selected. If I use AND all or no records are
returned.

What I want:
Results limited and based on any combination of the criteria.

If anyone has any suggestions it would be most appreciated.

Mary
 
O

Ofer

in the criteria for each field in the query try and wite

like (nz(Forms![FormName]![FieldName],"*"))
 
Top