NorthWind Question

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I'm probably missing something really obvious here but I am trying to copy
the way the orders form and subform combine to create a total on the orders
form.

Looking at the orders sub form In would expect the Extended price to be
something like =[Unit Price]*[Quantity] (not using the correct field names
here), but it just says Extended Price. I can't spot any function that is
doing the work either.

In trying to emulate this in Access 2003 I am getting an #error in the Order
SubTotal box.

Can anyone help please.

Ta.
Bill
 
It actually says =Sum([ExtendedPrice]) where Sum is the function and
ExtendedPrice is the text box.
Ed
 
Bill,
Check out the query behind the Order form. It has a calculated field
ExtendedPrice: CCur([Order Details].[UnitPrice]*[Quantity]*(1-[Discount])/100)*100
This creates a "bound" calculated field (ExtendedPrice) that can be directly added up
in the form footer.
If ExtendedPrice were a "calculated on the form field" of
= [UnitPrice]*[Quantity]*(1-[Discount])/100)*100
it would still yield the same value, but as an "unbound" calculated field...
= Sum(ExtendedPrice) in the footer would fail with #error.
 
Bill said:
I'm probably missing something really obvious here but I am trying to copy
the way the orders form and subform combine to create a total on the
orders form.

Looking at the orders sub form In would expect the Extended price to be
something like =[Unit Price]*[Quantity] (not using the correct field
names here), but it just says Extended Price. I can't spot any function
that is doing the work either.
Click to expand...

It's calculated in the "Order Details Extended" query.

Keith.
www.keithwilby.com
 
It's calculated in the underlying query that serves as the recordsource for
the subform, Order Details Extended.
 
If you check the source of Customer Orders Subform2 you will see that it is
Order Details Extended. Look in the Extended Price field and you'll see the
formula:
ExtendedPrice: CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)
*100
I'm probably missing something really obvious here but I am trying to copy
the way the orders form and subform combine to create a total on the orders
form.

Looking at the orders sub form In would expect the Extended price to be
something like =[Unit Price]*[Quantity] (not using the correct field names
here), but it just says Extended Price. I can't spot any function that is
doing the work either.

In trying to emulate this in Access 2003 I am getting an #error in the Order
SubTotal box.

Can anyone help please.

Ta.
Bill
Click to expand...
 
For clarification:
Order Details Extended is a query and when I say Look in I'm mean look in
Order Details Extended in design view.
Sorry
If you check the source of Customer Orders Subform2 you will see that it is
Order Details Extended. Look in the Extended Price field and you'll see the
formula:
ExtendedPrice: CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)
*100
I'm probably missing something really obvious here but I am trying to copy
the way the orders form and subform combine to create a total on the orders
Click to expand...
[quoted text clipped - 12 lines]
Ta.
Bill
Click to expand...
Click to expand...
 
Thanks to everyone, I had not spotted that the form was based on a query.
All is ok now.
Thanks again.
Bill.
 
Back
Top