I have a contract date field (mm-dd-yy). how can I sum another field by just using the year?
K Karen Apr 11, 2006 #1 I have a contract date field (mm-dd-yy). how can I sum another field by just using the year?
K K Dales Apr 11, 2006 #2 Use a calculated column (e.g. ContractYear:Year([contract date])) and group that in your totals query
Use a calculated column (e.g. ContractYear:Year([contract date])) and group that in your totals query
T Tom Ellison Apr 11, 2006 #3 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
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
