How do I return the maximum value

[kam]

Hi,



I have a table that contains two fields. 1) Part Number. 2) Version. The table is going to be used to keep track of drawing versions for my Engineering department.

I want to be able to design a query that will return the latest version number for a given part Number
Version numbers are assigned from A. to Z and then from 1 -100. With A being the lowest value and 100 being the highest.

So for the example data :-

Part Number version
987680 C
987680 7
987680 1

I want the query result to display 987680 7 since this is greater than C and 1

How can I achieve this? I’m a newbie to Access and don’t really have a clue. Any help will be most appreciated.
Thanks.

[jgelpi16]

Click the "Sum" button on your tool bar. It looks like a large "E". Under your "Part Number" field there will be a row that says "Group By". Click on the drop-down and click on "Max". That should return what you are looking for. Let me know if it does not.

[kam]

Thanks,
I thought this would work, unfortuantely Alphabetical characters are appear to be greater than numbers.