N
Nathan Swartzlander
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?
I received some help from another user, but he didn't have access 2003.
Here is what we found:
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.
I'm not good at computing numbers in Access, so any help would be appreciated.
Thanks
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?
I received some help from another user, but he didn't have access 2003.
Here is what we found:
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.
I'm not good at computing numbers in Access, so any help would be appreciated.
Thanks