access calculation under these conditions

[chozze]

Hi to all,

I am workin with ms access just for a short time , I know just the
basics I need to know (queries, forms etc, but no vba or sql). I like
to make ms access to calculate something for me but I really dont know
where to start or even if it is possible.

GOODS PRICE PIECES TOTAL
cola 20 x 20x
beer 25 y 25y
nuts 10 z 10z
-------------------------------------------------
total 1000

This is simplified table, I have the prices of goods and the total
amount (1000) wich have been spend on goods. I need from ms access to
fill reqiured values (where is about 19 - 40 unknown in real) Does
somebody have any idea how to do it?

thx for any answers

chozze

 

[Allen Browne]

The first essential is that you don't store the Total column in your table
at all.

Instead, you create a query where Access calculates this for you.

For an example (very similar to yours), see:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html

Once you understand that, you may also be interested in the more advanced
topic of how to let the user enter the number of pieces and the total, and
have Access figure out the unit price to store. There's a sample of how to
do that here:
Enter text in calculated controls
at:
http://allenbrowne.com/TechniqueEnterCalcText.html

 

[Larry Daugherty]

You might study the Northwind example that came with Access. There
are lots of things there to analyze. There are also lots of templates
that you can download, setup and study.

HTH

 

[chozze]

thx for answers, maybe I describe the problem badly, I understand that
I need to use queries for calculations and so, but my point is not
just to count the prices from number of pieces wich user may entry. My
goal is to that the ms access calculate the unknow (no user are going
to enter them x,y,z).

Anyway some guys starts answering me at my nature language, so it
seems to be easier to solve problem there.

thanks once again

chozze