Ordering fields in query based on current date

[Smriti Dev]

Hi There,

I'm creating a form based on query and I want the appointments to be ordered
from top to bottom with the top appointments being closest to the currrent
date.
How can i set this up in my query?
I do appreciate your help with this.

Thanks,
Smriti

[lesperancer]

what is your current query

[PC Datasheet]

If you don't want to show future appointments, set the criteria of the
AppointmentDate field to <=Date(). To order the appointments starting with
the most current appointment, set the sort for Appointment to descending.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Smriti Dev" <sm********@utoronto.ca> wrote in message
news:IM********@campus-news-reading.utoronto.ca...

Hi There,

I'm creating a form based on query and I want the appointments to be
ordered
from top to bottom with the top appointments being closest to the currrent
date.
How can i set this up in my query?
I do appreciate your help with this.

Thanks,
Smriti

[Larry Linson]

"Smriti Dev" wrote

I'm creating a form based on query
and I want the appointments to be
ordered from top to bottom with
the top appointments being closest
to the currrent date.

Are you showing only future appointments? If so, in the Query Builder,
select Ascending in the Sort line under the date / time field of the
appointment. (And, I feel obligated to mention, that field should not be
named Date, because date is an Access reserved word.)

If you are showing appointments that are already past _and_ in the future,
you will have to come up with a different display scheme, something like
using the ABSolute of the DateDiff, if that gives you what you want.

Larry Linson
Microsoft Access MVP