Finding the largest size in a group

[compsci610]

I have a query that I am trying to find the largest number in a grouping
within a list . My data is as follows

857A046613
857A086613
857A166613

What I need is to be able to find the largest of the threein this group and
then move on to the next group and do the same thing. Any help would be
greatly appreciated.

 

[vanderghast]

Consider having one information per field, rather than 'encoding' the
information. Sure, sure, sure, the management probably like 'encoding' their
'product number' and so on, but that does not mean your database SHOULD do
the same. As example, with three fields:

f1 f2 f3
857 A 46613
857 A 86613
857 A 166613


not only your solution would be trivial (I hope), but you can PRINT on
REPORT what the management expect to see with simple concatenation of the
three fields:

f1 & f2 & Format(f3, "000000")


Vanderghast, Access MVP

 

[compsci610]

Thanks

Consider having one information per field, rather than 'encoding' the
information. Sure, sure, sure, the management probably like 'encoding' their
'product number' and so on, but that does not mean your database SHOULD do
the same. As example, with three fields:

f1 f2 f3
857 A 46613
857 A 86613
857 A 166613


not only your solution would be trivial (I hope), but you can PRINT on
REPORT what the management expect to see with simple concatenation of the
three fields:

f1 & f2 & Format(f3, "000000")


Vanderghast, Access MVP