Link between access report and excel 1

[mytaurus2000]

I have a report with groupings by Center, and displays ParticipantType and NumberOf Participants:

e.g.
Center1
Family 3
Education 4

Center2
Family 1
Education 3

The report is pulling from a query that has the column headings of ParticipantType, Center, and NumOfParticipants

I need to somehow transfer the data into an excel spreadsheet with the columns headings of ParticpantType, c1, c2, and Number of Participants. I need to have the excel spreadsheet to display as follows:

ParticipantType c1 c2
Education 4 3
Family 3 1

And if that can happen, I need to have the info link. So whenever I run the excel spreadsheet it has the current data from the access database.

Can someone work a miracle and help me?

 

[dhookom]

You should try create a crosstab query with Center as the Column Heading, ParticipantType as the Row Heading, and Count of Participants as the Value.

You could also create a pivot table in Excel that links directly to your Access table/query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mytaurus2000]

I apologized for double post, but I meant to place in reports forum and delete this one.

I thank you for the suggestion, the pivot table work beautifully.