Order DB Help

[jimd1768]

I am trying to build an orders database and I am using the access template as a guide. I hope someone can help with this query.

It has "Extended price" in the orders subform.
Firstly what is Extended price? This is what populates the Order Subtotal.
I tried to put a calculation in there: Quantity * Unit Price. This gives me a total but then the Order subtotal is blank.

Has anyone had experience with this samole database and can offer some help to resolve this. I have attached a picture to help explain what I mean.

Thank you

 

[HiTechCoach]

The Extend price is supposed to be the quantity * Unit price less any discount

In the sub form change the control source for the text box named Price to be:

=Nz([Quantity],0)*Nz([UnitPrice],0)*(1-[Discount])

In teh sub form's footer change the control sourece for the tect box OrderDetailsTotal to be:

=Nz(Sum(Nz([Quantity],0)*Nz([UnitPrice],0)*(1-[Discount])),0)

Also take a look at the query named [Total Price of Order Details]

Hope this helps ...

 

[jimd1768]

Thank you so much. This is perfect.

I really appreciate you taking the time help.

 

[HiTechCoach]

Thank you so much. This is perfect.

I really appreciate you taking the time help.

You're welcome.