Assum i had at reciept table, the customer made payment by :
1. Credit card = 100
2. Cash = 100
3. Cheque = 50

In a query field i assigned total : [credit card]+[cash]+[Cheque]



the total amount is 250 showed in query, but how can i store the amount to the reciept tabel ???

thanks