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

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
 
G

Guest

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameter Crosstab query filter by form 1
Checkboxes and Query Criteria 1
query criteria entered via a form 8
Query by Form 3
Search on entered or blank criteria 5
Query Criteria Null Values 2
Multiple Criteria 1
Query Criteria issue 5

Top