G
Guest
I have a table in which each record has a date associated with it. I need to
extract the record that has a date closest to a date entered on a form.
Specifically, it needs to be the record that is the highest in the table but
lower than or equal to the date on the form e.g. if the table contains
records with 20/01/2006, 20/2/2006 and 20/03/2006 and 01/03/2006 is entered
to the form, then I want to extract the record dated 20/02/2006.
How can this be done?
extract the record that has a date closest to a date entered on a form.
Specifically, it needs to be the record that is the highest in the table but
lower than or equal to the date on the form e.g. if the table contains
records with 20/01/2006, 20/2/2006 and 20/03/2006 and 01/03/2006 is entered
to the form, then I want to extract the record dated 20/02/2006.
How can this be done?