Hello,

Does anyone know if it is possible for me to set up a
query so that users in Group A can only see results for
Building A and users in Group B can only see results for
Building B?

ANy help would be appreciated.

Hi.

You'll need to create either a parameter query or two separate queries to do
this. The parameter query would require the building name in order to
specify the correct building name in the WHERE clause. The two separate
queries would each have the relevent building name in their WHERE clauses.

If you want to use user-level permissions on the two separate queries, then
you'll need to give permissions to run the appropriate query to the
appropriate group.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Naimah" <(E-Mail Removed)> wrote in message
news:20ea01c49a7a$9f78fad0$(E-Mail Removed)...
> Hello,
>
> Does anyone know if it is possible for me to set up a
> query so that users in Group A can only see results for
> Building A and users in Group B can only see results for
> Building B?
>
> ANy help would be appreciated.