Query - Group by Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a contract date field (mm-dd-yy). how can I sum another field by just
using the year?
 
Use a calculated column (e.g. ContractYear:Year([contract date])) and group
that in your totals query
 
Dear Karen:

If this is a date/time field, it may be formatted mm-dd-yy but that is
irrelevant. Formatting is just how you see the data, not how it is stored
or how it functions.

The Year() function will extract the integer year value from this.

GROUP BY Year(YourDate)

Tom Ellison
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering Criteria Question 2
Date format 1
convert date field to month/year 1
CDate and gloabal date settings 7
Date comparison 2
Sums Way to big 7
Formatting date gives bad results in query 2
Parameters in a crosstab. 3

Back
Top