Order Management Template off of Microsoft.com

  • Thread starter Nathan Swartzlander
  • Start date
N

Nathan Swartzlander

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top