Forums | Help | Site Map

Join Bytes
Login

network: 226,501 (1479 online)

bytes

Max or Most Recent Date

Proaccesspro Proaccesspro is offline

Proaccesspro is offline

Familiar Sight

Join Date: Apr 2007

Posts: 132

#1: Aug 27 '07

I have 2 tables in a query. One of the tables contains a field titled Action Date. How can I query for the most recent date in the field Action Date?

Dmax?

Rabbit is offline

Expert

Join Date: Jan 2007

Location: California

Posts: 3,835

#2: Aug 27 '07

re: Max or Most Recent Date

View > Totals
Choose Max from the drop down list.

Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

SELECT entire row containing MAX([Start]) (answers)
Most Recent Dated Record, perhaps I am not seeing it correctly. (answers)
Need SQL Query to determine max value from fields in a row (answers)
Select Max to Get Value for Field (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved