Create reports for selected users

[pfales]

Hello, I have an ACCESS tool that I am creating that will be utilized by multiple people and I am having difficulty in trying to design the reports to where when a user creates a report they only receive the information they have entered and not everyones information. Example- Users Steve, Jerry, Janet, Susan have all made multiple entries to the data base. At the end of the week (or when desired) Janet wants to print out a report that shows all of her activity. How can I create the report, or qry (if that is what is needed) that will allow this to happen? Or is there a VB script that I can use to do this?

[pbaldy]

One way is a parameter query, another is this:

http://www.baldyweb.com/wherecondition.htm

[pfales]

One way is a parameter query, another is this:

http://www.baldyweb.com/wherecondition.htm

pbaldy,

Thank you for the assistance and the information I will give it a whirl and let you know how it turns out.

[pbaldy]

No problem, and welcome to the site by the way! Post back if you get stuck.

[pfales]

No problem, and welcome to the site by the way! Post back if you get stuck.

Tried both methods with success THANK YOU, I did pay with the information you gave to see what would happen with variations added. Lesson learned stick with the original advice.

[pbaldy]

Happy to help!