Grouping Amount with total per client

[Aslion]

Hi there,

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

100360	Dhr.	A	Client A			31-12-2018	Product A	227,00	-0,02	-227,00
						31-12-2018	Product A	227,00	-0,02	-227,00
						31-12-2018	Product A	227,00	-0,02	-227,00
						31-12-2018	Product B	227,00	0,02	227,00
						31-12-2018	Product B	227,00	0,02	227,00
						31-12-2018	Product A	227,00	0,02	227,00
100628	Mw.	B	Client B			31-12-2018	Product A	343,00	-0,02	-343,00
						31-12-2018	Product A	1,00	-0,02	-1,00
						31-12-2018	Product B	343,00	0,02	343,00
						31-12-2018	Product B	1,00	0,02	1,00
						31-12-2018	Product B	354,00	0,02	354,00

<tbody>
[TH="bgcolor: #c0c0c0"] id [/TH]
[TH="bgcolor: #c0c0c0"] geslacht [/TH]
[TH="bgcolor: #c0c0c0"] initialen [/TH]
[TH="bgcolor: #c0c0c0"] naam [/TH]
[TH="bgcolor: #c0c0c0"] voorvoegsel [/TH]
[TH="bgcolor: #c0c0c0"] geboortedatum [/TH]
[TH="bgcolor: #c0c0c0"] datum [/TH]
[TH="bgcolor: #c0c0c0"] product [/TH]
[TH="bgcolor: #c0c0c0"] tarief [/TH]
[TH="bgcolor: #c0c0c0"] Quantity [/TH]
[TH="bgcolor: #c0c0c0"] Amount [/TH]

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

 

[xenou]

If you have the excel sheet it would be relatively simple to fill it in first, then import it to access.

See here:
https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/

 

[Aslion]

Thanx for the help! Filling the blanks fields has worked I'll try now with the filled ID's