B
Boz
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,
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,