Formating Data by the use of Queries

S

spacecadet

I have two queries that do not have a matching field they also do not have a
matching number of records.

One Query is a table like below

Record1:
User Name: Sarah Mertens
GroupAccess1:a1
GroupAccess2:e2
GroupAccess3:car
GroupAccess4:plane

Record 2:
User Name: Brandon Teague
GroupAccess1:car
GroupAccess2:fish

The second query is has on one field and looks like below:

Record1:
Group: a1

Record2:
Group:2

Record3:
Group:car

Etc....

I would like to produce a query or table or report (whichever is easier)
that will format the data like....

a1 e2 car
plane etc.
Sarah Mertens Sarah Mertens Sarah Mertens Sarah
Mertens
Brandon Teague

Can anyone help?
 
Top