updating spreadsheets and/or pivot tables

[Xabu]

I'm new with this.

I'm interested dow can I add spreadsheets to my reports, I need to show the data from my database in the form of spreadsheets or pivot tables. If that is possible at all.

For example, I have a database that keeps track of how many guests of what nationality spent time in one of our hotels, I need to present that in a form of a table/spreadsheet in one of my reports, and i have to do it every month.

Thanks1

 

[Rich]

It sounds as though you're looking for a crosstab query

 

[Xabu]

Thanks ... you solved more than one problem I had