CAN'T SEE MY COLCULATIONS IN TABLE

[Guest]

I MADE 2 TABLES 1)HAS TWO FIELDS A)PRODUCTS B)PRICE. 2)VARIOUS FIELDS 1 IS
LIST WITH PRODUCTS
I MADE THE FORM AND IN ONE FIELD I WENT PROPERTIES CHECKED SOURCE PRODUCTS
AND IT SHOWS THE PRICE BUT IN THE TABLE IT DOES'T APEAR
I HAVE TO HAVE IT ON TABLE BECAUSE I WANT TO MAKE A REPORT WITH TOTALS WHAT
DID I DO WRONG?

 

[Pieter Wijnen]

You're breaking Netiquette by SHOUTING.
Please do not if you want answers

Pieter

 

[Joseph Meehan]

I MADE 2 TABLES 1)HAS TWO FIELDS A)PRODUCTS B)PRICE. 2)VARIOUS FIELDS
1 IS LIST WITH PRODUCTS
I MADE THE FORM AND IN ONE FIELD I WENT PROPERTIES CHECKED SOURCE
PRODUCTS AND IT SHOWS THE PRICE BUT IN THE TABLE IT DOES'T APEAR
I HAVE TO HAVE IT ON TABLE BECAUSE I WANT TO MAKE A REPORT WITH
TOTALS WHAT DID I DO WRONG?

~~~~~~~~~~~~~~~~~~~
I made 2 tables 1)has two fields a)products b)price. 2)various fields 1 is

list with products.



I made the form and in one field I went properties checked source products
and it shows the price but in the table it does't apear.



I have to have it on table because I want to make a report with totals what
did I do wrong?

~~~~~~~~~~~~~~~~~~~~

That's better. I can even read it. However I can't understand it.

If my guess is right, your problem is the totals. Totals should not be
stored in a table. Totals are computed as needed. Storing them creates
all kinds of problems. You need to compute the totals on the report.


Maybe some more specifics with examples. This time don't use ALL CAPS.
They are very difficult to read and are not very polite. A poor way to ask a
question.

 

[Guest]

I'm very sorry. I'm from Greece and it's the first time i am in this site.
I'm trying to do something!! in Access but i've been having problems. If you
have a form and you make in a field ( properties =sum(sth), when i go to the
table in that field it does't show. Do you understand now? I want it to the
table so when i make a report i can make another 'field' to do =sum() if my
table is emty the sum is 0

 

[Joseph Meehan]

I'm very sorry. I'm from Greece and it's the first time i am in this
site.

No problem. If I had to try and write in Greek we would never get
anywhere.

I'm trying to do something!! in Access but i've been having
problems. If you have a form and you make in a field ( properties
=sum(sth), when i go to the table in that field it does't show. Do
you understand now? I want it to the table so when i make a report i
can make another 'field' to do =sum() if my table is emty the sum is 0

Two things:

1. Normally you do not want to store the result of a calculation like a
sum. Access can re-calculate it when you need it. Access will generally
work faster that way and if one of the numbers were to change the stored sum
would then be incorrect, but a computed sum would still be correct.

2. On the form you created a temporary sum. It only exist on that form.
I suggest that you may want to just repeat that process when ever you want
to see the sum, rather than trying to store it.

If you are going to use that same sum in different forms and reports,
you may want to make a query that computes the sum. That way you don't have
to re-write the formula and you can open the query to see all the sums
anything you like. Generally you should not use the table for viewing data,
but you can use the query.