Order By Question

Well all I changed was ReminderID to Reminder? The comparison was already < in that last verson of the DB? Admittedly, that was not what you had at the start, as shown in post 2.
You originally had a sort order in the form as well, now that has been removed.?
 
Thanks for sorting that out Paul.

@JamesJoey
The important point that comes from this thread is that you need to make sure you understand all code provided for you
I had held back from modifying the RankByDay expression I provided a month or two ago as I hoped you would work out the modification for yourself.

Anyway, the form looks good & I can see how it could be very useful
 
Yeah I understand.
But, I'm 66 years old. 25 years-ago I would've worked on it.
25 years ago I several access books on Access.
It's daunting for me.
I've gotten a bit complacent.
 
Thanks for sorting that out Paul.

@JamesJoey
The important point that comes from this thread is that you need to make sure you understand all code provided for you
I had held back from modifying the RankByDay expression I provided a month or two ago as I hoped you would work out the modification for yourself.

Anyway, the form looks good & I can see how it could be very useful
Colin,
Mainly for my benefit, as I remember changing the original post file to be sorted by date and time.
 
@JamesJoey
OK but I'm several years older than you ....and I'm still learning new things every day.
In fact that's what keeps my interest in Access alive!
 
And I'm 67, and never coded in Access for a living, so not much of an excuse? :)
 

Users who are viewing this thread

Back
Top Bottom