Criteria ?

[pungigis]

I have a query I want to be able to pull by a specific name or all names in the field, I can't get it to work, can anyone help.

 

[SkipVought]

Could you post a representative example?

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[pungigis]

Analyst Name
Lisa
Mary
Joe
John

Want to be able to pull a report by either LISA or a report of ALL lisa, mary, joe & john.

I have the following:

Analyst name

Criteria: [Enter Analyst Name]
or "*"

It's not working, it returns all no matter what I put.

 

[PHV]

Criteria: [Enter Analyst Name] OR Trim([Enter Analyst Name] & "") = ""

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Another way:
Criteria: Like [Enter Analyst Name] & "*"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JerryKlmns]

Would you like a combo on a form to do the filtering for the query? faq702-4538