Creating a simple Reciept

[uzman1243]

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

[June7]

Everything you want is basic Access functionality.

Review
http://datapigtechnologies.com/flash...mtoreport.html

Do calculations in query or textboxes
http://office.microsoft.com/en-us/ac...005188027.aspx

[orange]

Further to June's comments, I would advise you to use a naming convention that does NOT allow spaces or special characters in field and object names.
Don't store results of calculations. Use queries to do calculations as needed.
Do you have a normalized database?