append query problem

[sibbbra]

hi ,when append query, C-Add, is invoked, it should calculate Amount_Sale present on Form Main respective to the customer, but thats not i am getting. it gets without discount. i tried to set it but in vain. that can be checked in customer orders by customer report
any help

 

[sibbbra]

 

[sibbbra]

Balance should be equal to amnt net

 

[ebs17]

Simple percentages are part of standard schooling, not a specific programming problem.

100 percent - 10 percent = 90 percent

or implemented

AmntSale * ((100 - Discnt) / 100)

 

[sibbbra]

Simple percentages are part of standard schooling, not a specific programming problem.

100 percent - 10 percent = 90 percent

or implemented

AmntSale * ((100 - Discnt) / 100)

thanks for reply. kindly tell me how to work that out in sample attached db

 

[sibbbra]

attached

 

[arnelgp]

what do you expect?
there is no sample Data on the table for orders, tblorderproduct and tblorderpayment.

 

[sibbbra]

what do you expect?
there is no sample Data on the table for orders, tblorderproduct and tblorderpayment.

In append query , C-Add, in the last field, i.e
line total: [Rate_Amount]*[Quantity_Sold]
i want to get this instead

line total: ([Rate_Amount]-[Customers]![Discount_C]*[Rate_Amount]/100)*[Quantity_Sold]

But when i do so, the sub reports in Customer_Orders report Disappear i.e. The details appear, even though the Amount_Sale is updated correctly
plz help
I have uploaded with some data below

 

[sibbbra]

any help

 

[mike60smart]

Hi

See if this helps

 

[sibbbra]

still no help

 

[Pat Hartman]

Since you are unwilling/unable to participate, perhaps, you should offer to hire someone to solve your unspecified problems.

 

[sibbbra]

solved

 

[Gasman]

solved

All these one liners are NOT doing you any favours?

 

[bob fitz]

solved

For the benefit of all members, perhaps you'd care to share the solution?

 

[mike60smart]

solved

Hi
Your database needs to be looked at again to normalise your "Orders" table

It contains what are known as Repeating Groups- See screenshot attached.

Your tblorderproducts has no PK and it contains Lookup fields.
It looks like you have made a simple Customer - Orders - Items process into a very complicated process.

For those that download the Database I attached all I did on the final Report was add the calculated field to one of the SubReports
and then made a Reference to that Control on the Main Report to show the Balance.