SQL Grouping by Date(Quarter, Month, etc...)
Quote:
>I am using VB3 to create a multi database query program. Is there a way
>I can write an SQL query so that records are grouped by a Datefield
>Monthly and then a second field.
Group by Month(DateField) or Year, Weekday, etc. Can't think how to group by
quarter, although a report can do it easily.
/-------------------------------------------------------------------------\
| My parents went to Castro Street and all I got was this lousy .sig file |
| David Migicovsky | {*filter*}? Yes |
| Toronto, Ontario | Rich-Text Email gleefully accepted |
\____________________________|____________________________________________/
