queries

[tom]

I have six sales persons, can one query be made and
change the sales person without changing the criterra
each time. I want to make only one report that changes
with it?


Thanks
Tom
(e-mail address removed)

 

[Tom Lake]

I have six sales persons, can one query be made and
change the sales person without changing the criterra
each time. I want to make only one report that changes
with it?

In the criteria field of the query, under the salesperson's name use

Like "*" & [Enter Salesperson's Name] & "*"

Tom Lake

 

[Guest]

Tom Thanks! Do use the same wording to other criteria field i want to change
by facility...month...customer...?

I have six sales persons, can one query be made and
change the sales person without changing the criterra
each time. I want to make only one report that changes
with it?

In the criteria field of the query, under the salesperson's name use

Like "*" & [Enter Salesperson's Name] & "*"

Tom Lake

 

[Guest]

Tom Thanks! Di I use the same wording if I want others criteria field to
change?

I have six sales persons, can one query be made and
change the sales person without changing the criterra
each time. I want to make only one report that changes
with it?

In the criteria field of the query, under the salesperson's name use

Like "*" & [Enter Salesperson's Name] & "*"

Tom Lake

 

[Guest]

Tom, Thanks! I want to do this with other criteria field do I use the same
wording?

I have six sales persons, can one query be made and
change the sales person without changing the criterra
each time. I want to make only one report that changes
with it?

In the criteria field of the query, under the salesperson's name use

Like "*" & [Enter Salesperson's Name] & "*"

Tom Lake