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
"Nathan Swartzlander" wrote:
> That's a bummer. What is the link for the 2002 equivalent? I'll check that
> out.
>
> "Ken Sheridan" wrote:
>
> > 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
> >
> > "Nathan Swartzlander" wrote:
> >
> > > 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/te...CT101426031033
> > >
> > > If you can check it out and see what I might be able to change, that would
> > > be cool.
> > >
> > > Thanks
> > >
> > > "Ken Sheridan" wrote:
> > >
> > > > 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
> > > >
> > > > "NateJS345" wrote:
> > > >
> > > > > 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?
> > > >
> >
Similar Threads
