Here's my dilema....

I am trying to set up a database that will allow different sites to enter
operational data.  Some sample fields in the table:

Inbound receipts
Inbound completed receipts
Outbound load
Outbound exceptions

The data covers a number of different operational areas:

Shipping
Receiving
Financial
Human Resources (man hours worked, etc.)
Inventory Management
Customer metrics met

I had no problem setting up the tables, as well as a query that will
calculate the data entered (thruput volume, Inbound/Outbound ratio, etc.).  
The problem that I am encountering is that I cannot get the query to give me
the totals based on date ranges.  The reason I need this is that our calander
period runs differently from our customer's calander period.  Management will
need reports based on different date ranges.

I have tried making the query a "Make Table" query, then running a report
from this, but thus far, it is not working.

Any help that can be provided will be helpful.

Thanks,