Past 12 Months

  • Thread starter Thread starter ShrekUT
  • Start date Start date
S

ShrekUT

I would like to have a query that shown Sales for the past 12 months
The table is named ARH the fields are InvoiceDate, Subtotal, an
CustomerNo. This query will be used in a chart.

Thank you..
 
Never mind! The below seems to work just fine... BUT any othe
methods/approches would be intersting.
SELECT ARH.CUSTOMER, ARH.INVOICEDATE, ARH.TAXES, ARH.ADJUST
ARH.FREIGHT, ARH.SUBTOTAL, ARH.TAXES+[ADJUST]+[FREIGHT]+[SUBTOTAL] A
Total
FROM ARH
WHER
(((ARH.INVOICEDATE)>=DateSerial(Year(Date()),Month(Date())-12,Day(Date())
And (ARH.DATE)<=INVOICEDate()))
ORDER BY ARH.DATE
 
Never mind! The below seems to work just fine... BUT any othe
methods/approches would be intersting.
SELECT ARH.CUSTOMER, ARH.INVOICEDATE, ARH.TAXES, ARH.ADJUST
ARH.FREIGHT, ARH.SUBTOTAL, ARH.TAXES+[ADJUST]+[FREIGHT]+[SUBTOTAL] A
Total
FROM ARH
WHER
(((ARH.INVOICEDATE)>=DateSerial(Year(Date()),Month(Date())-12,Day(Date())
And (ARH.DATE)<=INVOICEDate()))
ORDER BY ARH.DATE
 
Back
Top