Query? Report?

[Skie]

Let me start off by saying I'm new to Access. I'm able to do everything in an Excel workbook, but I'd like to be able to quickly and easily generate a report. I tried a search, but "query" and "report" bring up a lot of topics. I have no idea what words to combine to get the result I'm looking for. I appologize if my answer is one page deep.

I have 8 tables. One table is a list of all users and provides me with information about the users (ID, manager, etc.). The other 7 tables provide me with data about specific programs and consists of only some users.

What I'd like to be able to do is compile the data so that it's a sum that's manager specific. I'd also like to be able to request just the data for May 2007 or the data from Januray 2007 to May 2007.

So the data:
Name Manager Total
John Jerrome 2,000
Jane Jerrome 1,000
Bill Filbert 2,000

Would return the report:
Manager Total
Jerrome 3,000
Filbert 2,000

I could run through the tables and generate a report with VBA, but my understanding is I should be able to do this with queries/reports.

 

[Skie]

I found the solution by playing around with queries. Apparently all I had to use was a Total: Group By and a Total: Sum.