return value forms

[hrov]

ok i know how to set the criteria of a query to the contents of a taxt/list/combo box from a form.
But is there a way i can change the return value of the query from a form, (e.g. returns the freatest value of something) instead of doing it manually and typing in 1 in the Return: box? does this need to be done with another macro?
Thanks for any help

 

[Poppa Smurf]

Use the Help menu and look at MAX function using a query.

 

[hrov]

ok thanks for reply, but the help menu of what?

 

[Poppa Smurf]

With the Database open use the F1 key to access the Help Menu in Access then type in MAX to search the file.

 

[hrov]

With the Database open use the F1 key to access the Help Menu in Access then type in MAX to search the file.

ok im not sure if i explained properly.
You know the "return value" box what lets you choose 1,5,25,100,5%,25% etc.
Well in my form i would like to use a listbox to select or input a number, as in someome my want to find the 5 greatest values, but next time wants 10 greatest values.
If this is explained in the help menu i couldnt find it. Thanks