Display the max value

[FJJ8613]

How do I display only the largest or smallest value in the query result?


Thanks

 

[mhartman]

Hello:
Open your query in design mode. Then select View, Properties from the menu. On the tab look at the Top Values selection.

Regards
Mark

 

[Rich]

Look up Max and Min in the help file

 

[FJJ8613]

Thanks alot.... I knew it was something easy