flag for most recent date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

florida fumbler - 15 Jan 2006 17:39 GMT

have a table with three fields: Parcel,date of sale, and most recent.

Want to cycle thru records, and flag the most recent sale for a single
parcel id.

Know logically how to do how I'd do it... but need advice on best way to
open table and loop thru it...

Reply to this Message

Duane Hookom - 15 Jan 2006 18:40 GMT

Is there a good reason for your application to store a value that can be
calculated in a query?
You can use
SELECT Parcel, Max([DateOfSale]) as MostRecent
FROM tblWithThreeFields
GROUP BY Parcel;

Signature

Duane Hookom
MS Access MVP
--

> have a table with three fields: Parcel,date of sale, and most recent.
>
[quoted text clipped - 3 lines]
> Know logically how to do how I'd do it... but need advice on best way to
> open table and loop thru it...

Reply to this Message

florida fumbler - 18 Jan 2006 14:01 GMT

tried building an access query but there does not seem to be a "MAX" function
that will work on a date ... would appreciate any help with this

> Is there a good reason for your application to store a value that can be
> calculated in a query?
[quoted text clipped - 10 lines]
> > Know logically how to do how I'd do it... but need advice on best way to
> > open table and loop thru it...

Reply to this Message

Duane Hookom - 19 Jan 2006 02:16 GMT

I don't know why you would think Max would not be available for date fields.
Did you get an error message?

Signature

Duane Hookom
MS Access MVP
--

> tried building an access query but there does not seem to be a "MAX"
> function
[quoted text clipped - 15 lines]
>> > to
>> > open table and loop thru it...

Reply to this Message