Calculation in Orders Management Database

[Guest]

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?

 

[Guest]

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

 

[Guest]

I tried to add the equation to the subform control, but it didn't work. It
just said error. I'm not sure what else to do. Calculating things in access
is my weak spot. Here is the link to that database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?pid=CT101426031033

If you can check it out and see what I might be able to change, that would
be cool.

Thanks

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?

 

[Guest]

I'm in a Catch 22 situation here (or Catch 2002 to be more accurate). I have
Office 2002 installed, but the link you posted is to an Access 2003 file.
There is an Access 2000 equivalent, which should run under Access 2002, but
if I try to download that it tells me that Access 2000 is not found on my
machine!

What bound controls do you have in the subform? The subform in the
Northwind sample database has controls UnitPrice, Quantity and Discount,
bound in each case to fields of the same name. It may simply be that you
need to change the control names in the expression if yours have different
names.

Ken Sheridan
Stafford, England

I tried to add the equation to the subform control, but it didn't work. It
just said error. I'm not sure what else to do. Calculating things in access
is my weak spot. Here is the link to that database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?pid=CT101426031033

If you can check it out and see what I might be able to change, that would
be cool.

Thanks

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?

 

[Guest]

That's a bummer. What is the link for the 2002 equivalent? I'll check that
out.

I'm in a Catch 22 situation here (or Catch 2002 to be more accurate). I have
Office 2002 installed, but the link you posted is to an Access 2003 file.
There is an Access 2000 equivalent, which should run under Access 2002, but
if I try to download that it tells me that Access 2000 is not found on my
machine!

What bound controls do you have in the subform? The subform in the
Northwind sample database has controls UnitPrice, Quantity and Discount,
bound in each case to fields of the same name. It may simply be that you
need to change the control names in the expression if yours have different
names.

Ken Sheridan
Stafford, England

I tried to add the equation to the subform control, but it didn't work. It
just said error. I'm not sure what else to do. Calculating things in access
is my weak spot. Here is the link to that database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?pid=CT101426031033

If you can check it out and see what I might be able to change, that would
be cool.

Thanks

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

:

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?

 

[Guest]

There is no version specific to Access 2002, but I found that if you scroll
down the page after getting the message that Access 2000 isn't installed
there is a button which allows you to download that version anyway.
Unfortunately it doesn't take us any further as the order details subform
doesn't even have a control for the 'extended price'. Also the subform is
based directly on a table, so, unlike in Northwind, there is no computed
column in a query.

You might like to repost your original question so someone who can open the
2003 version can download take a look at it. While the expression should be
straightforward enough, without being able to see exactly what the relevant
columns in the table are its difficult for me to give you a categorical
answer.

Ken Sheridan
Stafford, England

That's a bummer. What is the link for the 2002 equivalent? I'll check that
out.

I'm in a Catch 22 situation here (or Catch 2002 to be more accurate). I have
Office 2002 installed, but the link you posted is to an Access 2003 file.
There is an Access 2000 equivalent, which should run under Access 2002, but
if I try to download that it tells me that Access 2000 is not found on my
machine!

What bound controls do you have in the subform? The subform in the
Northwind sample database has controls UnitPrice, Quantity and Discount,
bound in each case to fields of the same name. It may simply be that you
need to change the control names in the expression if yours have different
names.

Ken Sheridan
Stafford, England

I tried to add the equation to the subform control, but it didn't work. It
just said error. I'm not sure what else to do. Calculating things in access
is my weak spot. Here is the link to that database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?pid=CT101426031033

If you can check it out and see what I might be able to change, that would
be cool.

Thanks

:

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

:

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?

 

[Guest]

Thanks, I'll do that

There is no version specific to Access 2002, but I found that if you scroll
down the page after getting the message that Access 2000 isn't installed
there is a button which allows you to download that version anyway.
Unfortunately it doesn't take us any further as the order details subform
doesn't even have a control for the 'extended price'. Also the subform is
based directly on a table, so, unlike in Northwind, there is no computed
column in a query.

You might like to repost your original question so someone who can open the
2003 version can download take a look at it. While the expression should be
straightforward enough, without being able to see exactly what the relevant
columns in the table are its difficult for me to give you a categorical
answer.

Ken Sheridan
Stafford, England

That's a bummer. What is the link for the 2002 equivalent? I'll check that
out.

I'm in a Catch 22 situation here (or Catch 2002 to be more accurate). I have
Office 2002 installed, but the link you posted is to an Access 2003 file.
There is an Access 2000 equivalent, which should run under Access 2002, but
if I try to download that it tells me that Access 2000 is not found on my
machine!

What bound controls do you have in the subform? The subform in the
Northwind sample database has controls UnitPrice, Quantity and Discount,
bound in each case to fields of the same name. It may simply be that you
need to change the control names in the expression if yours have different
names.

Ken Sheridan
Stafford, England

:

I tried to add the equation to the subform control, but it didn't work. It
just said error. I'm not sure what else to do. Calculating things in access
is my weak spot. Here is the link to that database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?pid=CT101426031033

If you can check it out and see what I might be able to change, that would
be cool.

Thanks

:

I've not seen the template in question, but I'd imagine it works similarly to
the sample Northwind database. In the order details subform in that the
ExtendedPrice control is based on a computed column in the underlying query
using the following expression:

CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100

It could also be done as a computed control in the form by making the
control's ControlSource property:

=CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100

and for the Order Sub-Total control:

=Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])/100)*100)

Ken Sheridan
Stafford, England

:

I downloaded the Orders Management Database Template from the Microsoft
Website. When I entered in the price, it didn't add up the total cost of the
item price times the number of items being ordered minus the discount. How
would I get it to calculate the total for each item?