Can you please help me out in a problem I have?I need to create a simple receipt on ms access.
Fields will include:
TransactionDate
ProductID
ProductName
UnitPrice
Quantity
SubTotal
Total
AmoundPaid
Balance
The subtotal= unitPrice*Quantity
Total = Addition of all subtotal
AmountPaid = How much each customer paid
Balance = AmountPaid - Total
Can you please tell me the fields the TABLE should contain? (Remember customers will purchase more than one product & there will be more than one reciept)
How I can generate a REPORT using a FORM ? The REPORT should contain the calculations. How do I make access do the caluclations?
Thank you very much