Combine 2 tables for a report

[Sandra Grawunder]

My boss wants to change the format for a report.
Presently I have 2 tables that I query to get attendants
for a convention. The master table contains the name,
address, etc. The second table contains the dates of the
reservations, these are linked by the PK of RID. My
report looks like this:

Name Reservation Dates
Jane Doe Monday, May 9
Jane Doe Tuesday, May 10

Harry Smith Monday, May 9
Harry Smith Tuesday, May 10
Harry Smith Wednesday, May 11

My boss wants the report to look like this:

Name Monday Tuesday Wednesday
Jane Doe X X
Harry Smith X X X

How do I construct a query to convert the records from
the Reservation Table into fields for each RID in the
query?

Thanks so much,
Sandra G

 

[John Vinson]

How do I construct a query to convert the records from
the Reservation Table into fields for each RID in the
query?

A Crosstab query will do this for you. Use the query wizard and select
the Crosstab option.

John W. Vinson[MVP]

 

[Sandra Grawunder]

John, thank you so much!
Sandra G

-----Original Message-----


A Crosstab query will do this for you. Use the query wizard and select
the Crosstab option.

John W. Vinson[MVP]
.