Query on 3 tables

[Anton van Rosmalen]

Hi,

I am trying to create a query that searches for its data
in several tables.

To be precise:

There are tables:
User, Usergroups and Groups shares.
I want to create a query that results in an overview of
the Usernames and correspondending Shares.
So the query should check in what Usergroups a User is in
and then add the corresponding (Groups)Shares to the User.
e.g.:
User1 Share1 Share2 Share3

Thanks in advance,
Anton.

 

[Duane Hookom]

There is a generic concatenate function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.