By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Most Current Dates to show on Subform

P: n/a
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?

Sep 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?
Sep 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.