Query question

[Amy]

Hi there:

I have a query shows two fields, Products Name and Serial
Number.

Since each product could have many serial numbers, I want
the query to show each product with the latest serial
number (The highest number of the each product range). I
have many products show in this query as well.

Any advices?

Thanks a bunch,

Amy

 

[amy]

Actually, I got it, thanks for any potential help.
Amy

 

[paul]

How did you do it???

-----Original Message-----
Actually, I got it, thanks for any potential help.
Amy


.