Query Max Value

[Guest]

I have a field which represents various dates meter readings were taken for a
customer. I need my query to pull only the most reacent reading. I can't
seem to figure out how to write the query to pull only the most recent date.
Please help!

--
Regards,

Bryan Brassell
Cypresswood Financial, LLC
Financial, accounting and process consulting
281-897-9141

 

[Brendan Reynolds]

SELECT TOP 1 tblTest.Reading, tblTest.DateRead
FROM tblTest
WHERE (((tblTest.CustomerID)=[Customer ID?]))
ORDER BY tblTest.DateRead DESC;

 

[Guest]

I don't know sql well - how can I translate that into an expression in the
query builder? You were correct in surmising the customer number is the key
between the fields - the next field would be the "Service_To" field from wich
I need the most recent date only for each customer. Thanks...
--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141

SELECT TOP 1 tblTest.Reading, tblTest.DateRead
FROM tblTest
WHERE (((tblTest.CustomerID)=[Customer ID?]))
ORDER BY tblTest.DateRead DESC;

--
Brendan Reynolds

I have a field which represents various dates meter readings were taken for
a
customer. I need my query to pull only the most reacent reading. I can't
seem to figure out how to write the query to pull only the most recent
date.
Please help!

--
Regards,

Bryan Brassell
Cypresswood Financial, LLC
Financial, accounting and process consulting
281-897-9141