Help w/ summarizing information

[Fyyzer]

Here's a brief summary of my problem.

Database 1 - daily sales figures for multiple restaurants (fields include: store, date, sales amount, customer count)

Database 2 - Summary database.

In Database 2 I'd like to be able have it show me a layout with the following:

Month - April 2001

Store 1 - Total Monthly Sales(Summarize total sales for 4/2001) & Total Customer Count (Summarize total customer count for 4/2001)

Store 2 - same info as store 1

Store 3 - same info as store 1

I'm just trying to summarize data but I don't know how to tell it WHICH data (or dates specifically) I want to summarize. Is this something that's going to be accomplished with Scriptmaker or do I have to do something ridiculous like make a ton of fields like TotalSalesApr01, TotalSalesMay01, etc.

I've been beating my head against a wall for days now on this and I have a feeling I'm just not looking at it in the right way. Any help would be greatly appreciated.

-Mike