Criteria

[AndyShuter]

Just added some criteria to one of my queries so that it prompts for an input when the form attached to the query opens.

When I input a name into the parameters box, it returns the records I want, but what I want to do is be able to override the input to return all the records in the query

I'm new to this game, so please go easy on me!

 

[FoFa]

Try entering a * (wildcard) instead of a value to return all rows.

 

[databasedonr]

Andy, using the wildcards in the parameter is pretty straightforward after you've done it once.

For example, enter in your criteria field

Like "*" & [Enter Your Parameter Stuff Here] & "*"

This will give you a wildcard at beginning and end of the field. Is this what you're after? Then, when you want to return all rows, simply select OK at the prompt, and it should return all rows. If you want specific records, give it something to look for in the parameter box.

Does that help?

 

[AndyShuter]

Thanks

Woks a treat - many, many thanks

Andy