Aggregate Date Difference - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Aggregate Date Difference

Michael Jones

6 years ago

Hi Richard
I,m having trouble with calculating the number of years between two date. In my agg query with Totals on i have a field alias FirstDate set Min and second field alias LastDate. Both are from a field named PaymentDate I,ve watched your tutorials and have tried all ways but have been unable to get it to work, it keeps rejecting the field name. Can you help.
Regards Mike

	Richard Rost @Reply 6 years ago
When you say "rejecting the field name," what do you mean by that? Are you getting an error message. I've seen it happen where you can't do calculations in the SAME query that you have aggregates turned on. In that case, make a 2nd query based on your aggregate query. Put your calculations in THAT one. I haven't covered this in a TechHelp video. Gimme a sec...

	Richard Rost @Reply 6 years ago
Here ya go: Calculations on Aggregate Results

	Michael Jones OP @Reply 6 years ago
Thanks Richard that works great, glad your around to help

	Richard Rost @Reply 6 years ago
My pleasure

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View