Simple sum question

[misucu99]

I have a table and a form for it. ID, customer name, date, amount !
I want the total to date amount for that costumer to show up on the form when filling up a new record for it.

I'm a begginer!
thx

 

[MStef]

Hello misucu99!

I have constructed something, I think it is what you need.
Look at "DemoSimpleSumA2000.mdb",
look at tables, "Form1".
Open form and try.

 

[misucu99]

Thank you for your time.
I'm happy now !

but ... can we have that cell to show the total from all entries for that costumer not just for the current date.

Thank you again !

P.S. I'm still practicing! Promise, one day I can do it myself!

 

[MStef]

Hello misucu99!

Look at "Demo" a new one.
I appended some VBA, I think it is what you need.

 

[misucu99]

Thank you!

now is exactly what I need!

I'll do the fine tuning for design and buttons and ... I'm happy again!

regards,
m