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
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