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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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],"*"))
 
Back
Top