Most Current Dates to show on Subform

[jmarr02s]

I created a subform with 4 separate fields (textboxes) each containing
an 8 digit date

I want the most current date to show in each of the four fields
So under properties for the subform under Order By I entered the
following:

SATermDate DESC, CMSTermDate DESC, SATermDateRescinded DESC,
CMSTermDateRescinded DESC

This first two fields display the most current date (09/07/2006 showing
first), however the last two cells do not completely order from most
current to least current date

Any suggestions?

[ManningFan]

Depends on your data. You can't order fields arbitrarily. I'd go into
the recordsource property of the subform and set each field to order
descending. However, if SATermDate is 09/07/2006 and the
CMSTermDateRescinded for that record is 01/01/2006 then that's what's
going to show there. You can't change the order within a record.

jmarr02s wrote:

I created a subform with 4 separate fields (textboxes) each containing
an 8 digit date

I want the most current date to show in each of the four fields
So under properties for the subform under Order By I entered the
following:

SATermDate DESC, CMSTermDate DESC, SATermDateRescinded DESC,
CMSTermDateRescinded DESC

This first two fields display the most current date (09/07/2006 showing
first), however the last two cells do not completely order from most
current to least current date

Any suggestions?