Queries

[Guest]

Hi, Every one

I have a quick question. I created a database a while ago for our
collections team. They have reports that they print out but they all print
out together. Is there a way for me to set it up to pull up certain id
numbers at a time. I use the Like "*1234" but that pulls them all up
together.

If anyone could help, please
Thank you
Sheria

 

[Joseph Meehan]

Hi, Every one

I have a quick question. I created a database a while ago for our
collections team. They have reports that they print out but they all
print out together. Is there a way for me to set it up to pull up
certain id numbers at a time. I use the Like "*1234" but that pulls
them all up together.

If anyone could help, please
Thank you
Sheria

There are many ways. You can set a filter on a report or you can filter
the data in a query using the criteria line.

 

[Guest]

Thank you, can i type in [Enter Staff ID:] in the Criteria in Query.

Sheria

 

[Joseph Meehan]

Thank you, can i type in [Enter Staff ID:] in the Criteria in Query.

Sheria

There are many ways. You can set a filter on a report or you
can filter the data in a query using the criteria line.

Sure can.