Multiple Date Diff - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Date Diff

David Clement

14 months ago

Dear Richard,
I have made what I am calling a Gas Log to track Purchases, Price Per Gallon, How Many Gallons, How Much Was Spent and the Date Purchased. It all works just fine, but I would like it to able to tell me how many days between fill ups. I have tried doing a DateDiff but cant quite figure out how to do this in a for the lack of a better term a running DateDiff. I would like to be able to do an Average Number Of Days between the fill ups too.
These are some of the dates.
1/2/2025
1/13/2025
1/22/2025
2/5/2025

	Alex Hedley @Reply 14 months ago
DateDiff

	David Clement OP @Reply 14 months ago
Will DateDiff work in a sequence and do it automatically?

	Alex Hedley @Reply 14 months ago
Depends how you code it :p You could do a recursive function if necessary. Just depends exactly what you want to do. What's your structure and setup like?

	Alex Hedley @Reply 14 months ago
Running Balance is covered in Access Expert Level 29

	David Clement OP @Reply 14 months ago
Sample: DateOfFillUp 2/28/2025 DateOfFillUp 3/11/2025 DateOfFillUp 3/24/2025 and so on. I dont know how to do previous fill up date to current fill up date and see the number of days between each consecutive fill up.

	Alex Hedley @Reply 14 months ago
You could use a SubQuery http://allenbrowne.com/subquery-01.html

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

Next Unseen

New Feature: Comment Live View