Query/Form Table help

L

Lou

Hello!

I have a table that which has the following data housed.

[EventDate]
[Period]
[Year]
[ReportDate]
[AcountName]
[BlockedRooms]
[Revenue]

I have a report driven of this that gives me the total
number of rooms blocked by year and by period.

I now would like to create a table that houses just the
totals of the report by period and year. What would be the
best way to approach this, in a query or what..? I'm a
little slow..

Thank you.
Lou
 
Top