Order By Question

[Gasman]

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.?

 

[JamesJoey]

OK. Got it.

Thanks much,
James

 

[isladogs]

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]

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]

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]

@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]

And I'm 67, and never coded in Access for a living, so not much of an excuse?

 

[JamesJoey]

Maybe I should have used the term gotten lazy?

 

[isladogs]

Maybe I should have used the term gotten lazy?

We could get lazy about replying to your questions

 

[JamesJoey]

I wouldn't care for that,