I would like to add values for different products and get the total value in Ma access.
e.g
PRODUCT_NAME UNIT_PRICE QUONTITY
Fanta 100 10
Cock 80 5
Pepsi 70 15
Now How do i get total for the three comodities and represent the expression in a field in ms access querry or form?
Thanks,
Regards,
Gerald.