Home > IT Answers > Microsoft Windows > max query expression
Mwatters
5 pts.
 max query expression
Microsoft Access 2003, Microsoft Access queries
have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

Software/Hardware used:
access 2003
ASKED: February 14, 2012  2:51 PM
UPDATED: February 27, 2012  8:42 PM
RELATED QUESTIONS
Answer Wiki:
You would have to use the <a href="http://www.techonthenet.com/access/functions/numeric/max.php">MAX function</a>
Last Wiki Answer Submitted:  February 14, 2012  2:58 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _