Getting the highest value

[mama16]

Hello, I need to create a query that will give me the highest and lowest value. For example

25666
25999
26000
24000
22222
45000
10000

How can I have Access to pick 45000 and also pick 10000?
Any ideas?

 

[CosmoKramer]

Check out Access help for the Min and Max functions:

SELECT Max([YourfieldName]) As MaxYourFieldName......FROM YourTableName

I'm CosmoKramer, and I approve this message.

 

[mama16]

I want to get one highest value. I'm getting all the values. For exanple I get the data like this

56000
45265
41021
32000
22002

It's giving me the highest value on top and that;s good but I don't need Access to show the others, I want 56000 to show by itself along with the other values like

A 586956
B 626332
C 570000
D 562333

I did a grouping by but I still get all the values, highest value on top

Any ideas?

Thanks

 

[CosmoKramer]

Did you try the syntax I posted above??

SELECT Max([YourfieldName]) As MaxYourFieldName FROM YourTableName

This will return only one record, in this case the highest value of YourFieldName.

I'm CosmoKramer, and I approve this message.

 

[mordja]

mama16,

Do as Cosmokramer said - NO GROUPING. Incidentally if you want the min as well do


SELECT Max(YourTable.YourField) AS MaxOfField, Min(YourTable.YourField) as MinOfField
FROM YourTable;


Mordja