Data from Tabular Form

[danian]

I have a tabular form for a sales database. i.e:

Product Qty Cost
Cherry Coke.........1...............0.95
Diet Coke............1...............0.95
Sprite.................1...............0.55
Cherry Coke.........1...............0.95

I want a command button to open a new form and show total product quantity and total cost, but on a normal form. i.e:

Product Qty Cost
Cherry Coke........2...............1.90
Diet Coke...........1................0.95
Sprite................1................0.55
..........................Total:........3.44

How can this be done?

Thanks
D

 

[danian]

Can anyone help with this?

Thanks
D