S Sal Mar 25, 2004 #1 Hi Can anybody tell me how to search for the highest value in a query. Cheers. Sal
J John Viescas Mar 25, 2004 #2 Use the MAX aggregate function in a Totals query. -- John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ (Microsoft Access MVP since 1993)
Use the MAX aggregate function in a Totals query. -- John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ (Microsoft Access MVP since 1993)
