flag for most recent date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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;
 
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

Duane Hookom said:
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;

--
Duane Hookom
MS Access MVP
--

florida fumbler said:
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...
Click to expand...
Click to expand...
 
I don't know why you would think Max would not be available for date fields.
Did you get an error message?

--
Duane Hookom
MS Access MVP
--

florida fumbler said:
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

Duane Hookom said:
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;

--
Duane Hookom
MS Access MVP
--

florida fumbler said:
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...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top