crosmill
Registered User.
- Local time
- Today, 02:48
- Joined
- Sep 20, 2001
- Messages
- 285
I have a query with product code and name (who ordered) this is grouped so that multiple orders by the same person are simply added.
I have a text field in the orders table for "Special Requirments" when the query is grouped then any special requirments are treated as a *new* group.
So...
prod1 bill 10
prod2 bill 15
prod2 bill 5 extra large
prod2 bill 5 extra small
What I want is
prod1 bill 10
prod2 bill 25 extra large, extra small
I know it doesn't makes sense in the example but the real comments make sense so it can be viewed this.
I can't work out if it can be done in query, I could do it in code but the occurance of these *Special Requirments* isn't worth the effort to write it.
Anyone have any ideas.
I have a text field in the orders table for "Special Requirments" when the query is grouped then any special requirments are treated as a *new* group.
So...
prod1 bill 10
prod2 bill 15
prod2 bill 5 extra large
prod2 bill 5 extra small
What I want is
prod1 bill 10
prod2 bill 25 extra large, extra small
I know it doesn't makes sense in the example but the real comments make sense so it can be viewed this.
I can't work out if it can be done in query, I could do it in code but the occurance of these *Special Requirments* isn't worth the effort to write it.
Anyone have any ideas.
