T
Tom
I have a table w/ a few hundred records. The table contains various fields
plus a date field.
I need to create a query that retrieves all records and puts FALSE into all
records (date field) except for the single record that has the most recent
date.
So, the record w/ the most recent date (MAX date) should have a TRUE in the
date field?
How do I do that?
plus a date field.
I need to create a query that retrieves all records and puts FALSE into all
records (date field) except for the single record that has the most recent
date.
So, the record w/ the most recent date (MAX date) should have a TRUE in the
date field?
How do I do that?