view a report

[gls858]

I have a database to track our employees vacation, sick days etc.
There is a report that we print that shows all of the detail for
the year for each employee. As you can imagine toward the end of
the year this report can get pretty big.

Question: Is there a way I could allow each individual to view
a report of their info and only their info? That way we wouldn't have to
print it out.


gls858

 

[Eric Blitzer]

I have an application similar to yours. What I do is to tie the access or
windows login to the query. I have a table with the name and login ID. The
query only pulls info based on the login name.