NorthWind Question

[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

 

[Ed]

It actually says =Sum([ExtendedPrice]) where Sum is the function and
ExtendedPrice is the text box.
Ed

 

[Al Camp]

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.

 

[Keith Wilby]

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.

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

Keith.
www.keithwilby.com

 

[Douglas J Steele]

It's calculated in the underlying query that serves as the recordsource for
the subform, Order Details Extended.

 

[jahoobob via AccessMonster.com]

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

 

[jahoobob via AccessMonster.com]

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

[quoted text clipped - 12 lines]

Ta.
Bill

 

[Bill]

Thanks to everyone, I had not spotted that the form was based on a query.
All is ok now.
Thanks again.
Bill.