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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"chozze" <(E-Mail Removed)> wrote in message
news:a1bc0fa3-00ef-4fbb-868e-(E-Mail Removed)...
> 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

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
--
-Larry-
--

"chozze" <(E-Mail Removed)> wrote in message
news:a1bc0fa3-00ef-4fbb-868e-(E-Mail Removed)...
> 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

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