Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries in Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Queries in Access
Resolved · Low Priority · Version 2007
Reply Thu 2 Jun 2011, 15:51Delegate Alex said...
Alex has attended:
Access Intermediate course
Access VBA course
Queries in Access
Is it possible to create a total column (by CustomerID) in a query of another column without the data being grouped? The DealID is unique.
i.e.
CustomerID/DealID/Value/Total
1 a 10 40
2 b 20 60
1 c 30 40
2 d 40 60
If this is not clear please let me know.
Thanks
Alex
For upcoming training course dates see: Pricing & availability
RE: Queries in Access
Hi Alex
Thanks for your question
Having looked over your requirements, I am slightly unsure as to how you see this query being laid out.
As the data isn't to be grouped would envisage the totals being repeated on each line for the relevant customer?
Thanks
Stephen
|