Highest number last used in a group

S

SDDiamonds

We determine our own ProductIDs and I need to write a query that will let me
know what the last number used (or the next sequestial one that's free) is in
a given catagory. Can anyone help?
 
Top