Parameter Query using Like with Leave Blank to See All

[BLFOSTER]

Hi I am sure this is simple, but I cannot figure it out. In my query grid: Field Name is "Activity". I want the user to be able to type a part of the Activity name when prompted, so as criteria I am using this: Like "*" & [Enter any part of Activity to search by, Leave Blank to See All: ] & "*"

Now I want the user to Leave Blank to See All: Expr1: Like "*" & [Enter any part of Activity to search by, Leave Blank to See All: ] & "*" Criteria under Expr1: Is Null or Is Not Null.

The Query tells me my Expr1: has invalid syntax and highlights the word "Like".

How can I make this do what I want?

Thanks so much!


Becky

[orange]

Remove that criteria and try again.

example sql

SELECT AnimalsAndLocations.AName, AnimalsAndLocations.SightingDate, AnimalsAndLocations.GPSLat
FROM AnimalsAndLocations
WHERE (((AnimalsAndLocations.AName) Like "*" & [enter something or leave blank for all] & "*"));

[BLFOSTER]

Perfect! Thank you!

[orange]

Great. Happy to help.