How do I do a query or report and display limited results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to extrapolate from an inventory database only those items
in use by a specific user. I have a "User" field and want to limit the
results only for a single user, such as "Joe". How do I do a query or create
a report which shows ONLY those items in use by "Joe"?
 
I've used the "criteria" option when creating a query. This is not the type
of short-cut I was looking for, especially since I have to either create a
new query for each value, or have to change and save the original query each
time I want a new list. Is there no other shortcut?

Thanks for any help you can offer.
 
Smig said:
I need to be able to extrapolate from an inventory database only those items
in use by a specific user. I have a "User" field and want to limit the
results only for a single user, such as "Joe". How do I do a query or create
a report which shows ONLY those items in use by "Joe"?
Click to expand...


Use a form for the user to allow the user to enter the name
in a text box. Then the query can use criteria like:
Forms!theform.thetextbox
 
Thank you, Marshall. So that I'm sure I understand, a form must be created
ahead of time for each specific user and include only that data which that
user is allowed to view, is that correct? (with security measures and
password-protection already in place, obviously) And can that user then
extrapolate only the included data that he or she wants to view, and create
his/her own query or report based upon that? (I've never had to protect
sections of an Access db before, so please pardon my ignorance)

Please let me know if I misunderstood.

And thanks much for your help!
 
SmigChick said:
Thank you, Marshall. So that I'm sure I understand, a form must be created
ahead of time for each specific user and include only that data which that
user is allowed to view, is that correct? (with security measures and
password-protection already in place, obviously) And can that user then
extrapolate only the included data that he or she wants to view, and create
his/her own query or report based upon that? (I've never had to protect
sections of an Access db before, so please pardon my ignorance)
Click to expand...


One form for all users. Just stuff the user name/value into
a text box and use that in the query's criteria. I have no
idea how you determine the user name/value, but if you're
using Access Security, I think you can use the UserName
property.
 
Back
Top