Month and YTD Values

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi folks

I have a query that returns sales records that include columns for;

Item - Description - Units - Dollars - Month Number

The column 'Month Number' contains a single number which represents eg 1 =
July.

I really need to work out how best to return results for month as well as
YTD, and realise I would probably need to create a query to include in
another query but wondered how I best do this?

Hope somebody out there can help.
 
Back
Top