G
Guest
I downloaded the order management template off of Microsoft.com.
Unfortunately in the orders form, the total for each item isn't being
calculated. I talked with Ken Sheridan on here, and this is what he found:
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:
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.
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.
Here is the link for the database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT101426031033
He didn't have Access 2003, and I do. Can someone help me fix that problem?
I'm not very good at calculating totals.
Thanks
Unfortunately in the orders form, the total for each item isn't being
calculated. I talked with Ken Sheridan on here, and this is what he found:
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:
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.
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.
Here is the link for the database:
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT101426031033
He didn't have Access 2003, and I do. Can someone help me fix that problem?
I'm not very good at calculating totals.
Thanks