Grouping Amount with total per client

Aslion

New Member
Joined
Mar 11, 2019
Messages
2
Hi there,

I have imported an excel sheet with 10k+ records in Access. Now i get an Table like this:
idgeslachtinitialennaamvoorvoegselgeboortedatumdatumproducttariefQuantityAmount
100360Dhr.AClient A

31-12-2018Product A227,00-0,02-227,00






31-12-2018Product A227,00-0,02-227,00






31-12-2018Product A227,00-0,02-227,00






31-12-2018Product B227,000,02227,00






31-12-2018Product B227,000,02227,00






31-12-2018Product A227,000,02227,00
100628Mw.BClient B

31-12-2018Product A343,00-0,02-343,00






31-12-2018Product A1,00-0,02-1,00






31-12-2018Product B343,000,02343,00






31-12-2018Product B1,000,021,00






31-12-2018Product B354,000,02354,00

<tbody>
</tbody>

This is how it is imported from the excel sheet. And just the first order of each client has an ID the other orders are blank. It is not possible tu fill in an ID because there are 10k+ records in it. Now i want to know the total order amount of each client. How do i have to make the querry?
<table border="1" bgcolor="#ffffff" cellspacing="0" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><thead></thead><tbody></tbody></table>

Thanks for the helps, and sorry for my bad english!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Aslion

New Member
Joined
Mar 11, 2019
Messages
2
Thanx for the help! Filling the blanks fields has worked I'll try now with the filled ID's
 

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top