Queries in Access

Resolved · Low Priority · Version 2007

Thu 2 Jun 2011, 15:51 Delegate 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

Wed 8 Jun 2011, 09:58 Trainer Stephen said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips