Order By Question (1 Viewer)

Gasman

Enthusiastic Amateur
Local time
Today, 12:52
Joined
Sep 21, 2011
Messages
14,052
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.?
 

isladogs

MVP / VIP
Local time
Today, 12:52
Joined
Jan 14, 2017
Messages
18,186
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
 

JamesJoey

Registered User.
Local time
Today, 08:52
Joined
Dec 6, 2010
Messages
608
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.
 

Gasman

Enthusiastic Amateur
Local time
Today, 12:52
Joined
Sep 21, 2011
Messages
14,052
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.
 

isladogs

MVP / VIP
Local time
Today, 12:52
Joined
Jan 14, 2017
Messages
18,186
@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!
 

Gasman

Enthusiastic Amateur
Local time
Today, 12:52
Joined
Sep 21, 2011
Messages
14,052
And I'm 67, and never coded in Access for a living, so not much of an excuse? :)
 

Users who are viewing this thread

Top Bottom