Group By Qtr

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I cant figure out how to group my records by quarters or months.Is there a
special query to otain these results? My current SQL is pretty basic using
two tables as the following:

SELECT VendorInv.EnterDate, VendorInv.InvDesc, VendorInv.InvCode,
VendorInv.InvAmt
FROM Vendor INNER JOIN VendorInv ON Vendor.VendorID = VendorInv.VendorID;

The format in EnterDate field is 01/01/2008 yet i am lost on the
grouping.Can this be done?
 
It can be done readily in a Report. Sort and Group on the EnterDate field in
the report. In the properties you can choose to group by day, week, month,
and quarter.
 
Back
Top