|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 23rd, 2009, 03:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Finding the largest size in a group
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. 
|
|
#2
December 23rd, 2009, 04:04 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Finding the largest size in a group
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" wrote in message ... 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.
|
|
#3
December 23rd, 2009, 04:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Finding the largest size in a group
Thanks
"vanderghast" wrote: 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" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
