I need a query expression to result below sorting,
Thanks
Table1
Model Qtty Red 1 Red 2 Red 3 Yellow 8 Yellow 4 Black 5 Orange 2
Query1
Red 6 Yellow 12 Black 5 Orange 2
I need a query expression to result below sorting,
Thanks
Table1
Model Qtty Red 1 Red 2 Red 3 Yellow 8 Yellow 4 Black 5 Orange 2
Query1
Red 6 Yellow 12 Black 5 Orange 2
I need a query expression to result below sorting,
Thanks
Table1
Model Qtty Red 1 Red 2 Red 3 Yellow 8 Yellow 4 Black 5 Orange 2
Query1
Model Qtty Red 6 Yellow 12 Black 5 Orange 2
You can use a Totals Query to get your sums.
Simply group by Model and Sum the Qtty field.
See here for details: http://www.fontstuff.com/access/acctut04.htm
However, what determines what order they should be sorted in?
Remember that the current "Order" the records are listed in in a Table really has no meaning.
Is there another field it can sort by?
Or do you have some sort of table that lists the different colors and how they should be sorted?
To sum the quantities create a Totals query (the E icon on the top). What is the sort order you need?
Thanks,
Sorry that was very elementary,
I am posting new thread
Duplicate threads merged since both had replies. In the future, please don't post the same question twice.