T
Tedj13
I have a query that combines 2 tables, a printers table and a readings table
the printer table contains Div group location and s/n and the reading table
contains date and reading
Div SN Group Location Date Counts
1 140044 Net Invoicing Area 29-Oct-07 4266483
1 140044 Net Invoicing Area 28-Nov-07 4433762
1 140044 Net Invoicing Area 28-Dec-07 4604691
1 140044 Net Invoicing Area 30-Jan-08 4792835
1 154243 General Office Area 29-Oct-07 379450
1 154243 General Office Area 28-Nov-07 387872
1 154243 General Office Area 28-Dec-07 396561
1 154243 General Office Area 30-Jan-08 407328
I need to calculate the # of pages that were printed in the previous month,
and compare that toal to the # of pages that were printed in the month prior
to that. Each printer has a unique SN. Any suggestions how to do this?
the printer table contains Div group location and s/n and the reading table
contains date and reading
Div SN Group Location Date Counts
1 140044 Net Invoicing Area 29-Oct-07 4266483
1 140044 Net Invoicing Area 28-Nov-07 4433762
1 140044 Net Invoicing Area 28-Dec-07 4604691
1 140044 Net Invoicing Area 30-Jan-08 4792835
1 154243 General Office Area 29-Oct-07 379450
1 154243 General Office Area 28-Nov-07 387872
1 154243 General Office Area 28-Dec-07 396561
1 154243 General Office Area 30-Jan-08 407328
I need to calculate the # of pages that were printed in the previous month,
and compare that toal to the # of pages that were printed in the month prior
to that. Each printer has a unique SN. Any suggestions how to do this?