Setting criteria in a query

[tinatt]

I'm trying to set my criteria in my query to print a report for my highest entered auto number only. Because this is continually changing, how do I set my criteria to print my report for only the highest numbered row?

 

[LonnieJohnson]

In the query design view, click the Totals button on the menu bar. It's a greek symbol that looks like an E. On the query grid you will have a line labled Total. Click on this line and a drop box arrow will appear. Choose Max from the list. This will give you the maximum value in that field.

B-) ljprodev@yahoo.com
ProDev
MS Access Applications