Help with adding criteria

[aubtiger14]

How do I add criteria for the sales rep number field that will allow me to enter a different sales rep each time the query is run?

[ItsMe]

Double click "sales rep number" in your query builder window and type some criteria in the new criteria field you just created.

[rpeare]

in the criteria of your sales rep number have something like

[Enter the Sales Rep Number]

The user will be prompted to enter a number and the query results will be based on whatever's typed in. If you want to look for anything matching a certain string and use wildcards you'd have to have something like


Like "*" & [Enter the Sales Rep Number] & "*"

so if you typed in

A12

and you had sales rep numbers of

A12334
A12345
A13543

the query would find the first two and not return the third.

[aubtiger14]

More specifically, do i need to enter that as an expression? and if so how do i do that?... i had to enter criterion to find all customers whose names start with the letter C and i entered it in the criterion field as Like "C*"

[aubtiger14]

that's what i needed...thanks

[ItsMe]

You can apply criteria at the form or report level too. This way your saved query object's usefulness is not limited to the criteria.