I am creating a database for a fictional store. I have a total of five
tables, one of which is called order details. I would like to have some ov
the coloms self caculate but my major problem currently is that unit price is
giving faulty prices for my products.

If you can help me for a bit I have MSN and my email address is
(E-Mail Removed)

Thanks for your time

How are you calculating the price? For one thing, calculations should be
performed as needed. In most cases you do not store the calculation
results. You can calculate in queries, VBA, or as the control source of
unbound text boxes.

"Niagera College Student" <(E-Mail Removed)>
wrote in message news:3683BC38-C6A8-4DE8-80F5-(E-Mail Removed)...
>I am creating a database for a fictional store. I have a total of five
> tables, one of which is called order details. I would like to have some ov
> the coloms self caculate but my major problem currently is that unit price
> is
> giving faulty prices for my products.
>
> If you can help me for a bit I have MSN and my email address is
> (E-Mail Removed)
>
> Thanks for your time

You don't perform calculations in a table. Access does not have that
capability, and it is not a good idea.

You are welcome to tell us SPECIFICALLY what you are trying to accomplish.

BUT... if this is an assignment for your class, then you should find other
resources for this. You should talk to your instructor or classmates. We
have already taken our classes and completed them, we don't want to do your
homework for you.

You can perform searches and find many many previous posts that talk about
the proper way to perform calculations in an Access database. The posts
from these newsgroups are available for a long time out on the web. Google
groups is a great resource to read previous posts.


--
Rick B



"Niagera College Student" <(E-Mail Removed)>
wrote in message news:3683BC38-C6A8-4DE8-80F5-(E-Mail Removed)...
>I am creating a database for a fictional store. I have a total of five
> tables, one of which is called order details. I would like to have some ov
> the coloms self caculate but my major problem currently is that unit price
> is
> giving faulty prices for my products.
>
> If you can help me for a bit I have MSN and my email address is
> (E-Mail Removed)
>
> Thanks for your time

Here is an idea of what I want to do, in the order details table there are
several heading including ( product) a pull down list ( quantity ) (unit
price) (total price)

I want to be able to select a product and have its corresponding price
appear in the price column, similarly I want to b e able to in put a quantity
and have the total price appear which would be (quantity) X (unit price)

This is part of a school project and what I am proposing to do is beyond my
teachers ability, I am also using Roger Jennings MS Access 2000 as itis the
latest material my school has on Access.

Any advise or direction would be well recived, thanks again.

Trevor Banu


"BruceM" wrote:

> How are you calculating the price? For one thing, calculations should be
> performed as needed. In most cases you do not store the calculation
> results. You can calculate in queries, VBA, or as the control source of
> unbound text boxes.
>
> "Niagera College Student" <(E-Mail Removed)>
> wrote in message news:3683BC38-C6A8-4DE8-80F5-(E-Mail Removed)...
> >I am creating a database for a fictional store. I have a total of five
> > tables, one of which is called order details. I would like to have some ov
> > the coloms self caculate but my major problem currently is that unit price
> > is
> > giving faulty prices for my products.
> >
> > If you can help me for a bit I have MSN and my email address is
> > (E-Mail Removed)
> >
> > Thanks for your time
>
>
>

Check out the Northwind.mdb example that came with Access. It has exactly
this function, not done in the table, which sounds like the basic problem
here. If u r a SS user remember Access is a database. It is not Excel with
funny menus.
--
SailorMike


"Niagera College Student" wrote:

> Here is an idea of what I want to do, in the order details table there are
> several heading including ( product) a pull down list ( quantity ) (unit
> price) (total price)
>
> I want to be able to select a product and have its corresponding price
> appear in the price column, similarly I want to b e able to in put a quantity
> and have the total price appear which would be (quantity) X (unit price)
>
> This is part of a school project and what I am proposing to do is beyond my
> teachers ability, I am also using Roger Jennings MS Access 2000 as itis the
> latest material my school has on Access.
>
> Any advise or direction would be well recived, thanks again.
>
> Trevor Banu
>
>
> "BruceM" wrote:
>
> > How are you calculating the price? For one thing, calculations should be
> > performed as needed. In most cases you do not store the calculation
> > results. You can calculate in queries, VBA, or as the control source of
> > unbound text boxes.
> >
> > "Niagera College Student" <(E-Mail Removed)>
> > wrote in message news:3683BC38-C6A8-4DE8-80F5-(E-Mail Removed)...
> > >I am creating a database for a fictional store. I have a total of five
> > > tables, one of which is called order details. I would like to have some ov
> > > the coloms self caculate but my major problem currently is that unit price
> > > is
> > > giving faulty prices for my products.
> > >
> > > If you can help me for a bit I have MSN and my email address is
> > > (E-Mail Removed)
> > >
> > > Thanks for your time
> >
> >
> >