Consolidating Data in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often need to consolidate data, with a number of variables upto a total
maxmium number of units.
e.g. two or more rows of identical cells (name,date etc) can be consolidated
upto a maximum of 30 units. Yes, quite easy....but if I have 3 rows with
values of 10, 15 and 6; I wish for the two larger to be consoldated into a
single row (a value of 25) and the remaining 6 to be left untouched.

In effect, I do not want any data row to be split ( as example above, the 6
into 5 and 1).

Anyone have an idea??
Appreciate your time Thanks
 
You can use whatever is common to your Units (name, date, etc.) to Sum the
values. Thus, you could do a query like this:

Select YourName, YourDate, Sum(SomeField)
From YourTable
Group By YourName, YourDate
 
Thanks you Lynn fro replying, but it appears your describing a simple query
to group data, thereby suming the units.
I shall attempt to clarify the specific problem.
The data is transport related, whereby I have a number of orders represented
by a data row. Each order has a specific address detail and value i.e 1
pallet. It happens that there are often several orders going to the same
address on the same day, which need to be grouped together into a single
delivery. The limit to any value grouped or not is 26 (26 pallets). The
problem is when, for example, three orders which could be grouped have values
of 20, 7 and 5. Since the limit of grouped orders is 26 AND no orders can be
split, the result should be two separate deliveries of 25 and 7 respectively.

I dont know how to tell Access the parameters, or even if its possible to do
so.

Kind regards
 
Ah, you're dealing with something like a warehouse management system. I
don't think what you want to do can be done with a simple query or even a
combination of queries.
 
Back
Top