Odd Total Problem

[Porky]

Hi
I have adapted the basic order enrty mdb, I have created an invoice to go with this without to many problems. I now want to create a report that shows sales figures for the day and or week. Not to difficult I agree but, and heres the bit that stumped me, the 'Total Sale' figure is calculated in a query which works fine. But my customers generally pay a deposit and then a balance and i want to show these on the day they are paid but when they pay the balance the total sale is added again to the report overinflating my sales figures. Is there any way of removing this data if the payment is a balance? my payments table does record 'Deposit', Balance' and 'Full'
Paul

 

[ScottGem]

Sounds like you may have a problem with the way your database is constructed. Sales are one thing and payments are another. They should be kept serparate.

If you could tell us more about your structure (or attach a sample) we can help more.

 

[Porky]

They are seperate I am using the standard order entry template that comes with access. I have modified the payments table, adding fields for Cash card etc. The Total sale is worked out in a query (also part of the template) to avoid staff entering the incorrect info (believe me they would) I want to utilise this in a report that allows me to do our accounts I need the total sale on payment of the deposit but not on any other payment. I could add a field to the payments form which employees enter manualy the total sale to overcome this but as i say they would get it wrong.

 

[ScottGem]

Not sure which template you are using, but your tables should identify the payments in such a way that you can filter out what you don't need.

 

[Rich]

Use a subReport to show payments per invoice