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

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

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

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

"FerryMary" wrote:

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