Calendar List Table - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Calendar List Table

Werner Mildt

21 days ago

In my calendar List Table, I have Holiday's, Appointments and more.
What I like to do is, getting the next date in my calendar after the
current date.
Not max or min dates.
Maybe using a query?
Would like to get some help with it!
Thanks Werner

	Kevin Robertson @Reply 21 days ago
Is this tomorrow's date? If today is Friday, is it Monday's date (workdays)? Is it the next available date?

	Werner Mildt OP @Reply 21 days ago
Kevin, Is it the next available date? Following the current date.

	Alex Hedley @Reply 21 days ago
You could create a Query that gets the TOP 1 from the Table of dates where the date > current date.

	Richard Rost @Reply 21 days ago
Or you could use DMIN and find the DMIN date where the date is greater than the current date.

	Werner Mildt OP @Reply 21 days ago
Thank you, Alex That worked perfect Regards Werner

Next Unseen

New Feature: Comment Live View