Calculations in Table

T

teelee

Can anyone tell me if there is a way to have a calculated field autopopulate
for a total column in a table? I know this can be done in a report, but I
need to know if it can be done in a table.


Thanks
 
W

Wayne-I-M

Bad Idea.

If you have a calculation result stored in a table you will end up having
incorrect data.

Store the data only in the table and do the calcuations in a query/form/report
 
T

teelee

But can I have the calculations showing in the Table? How would I set up the
Query?

Thanks
 
F

fredg

But can I have the calculations showing in the Table? How would I set up the
Query?

Thanks
Click to expand...

No, you cannot do a calculation in an Access table.

As Wayne suggested, do your calculation in a query, or on a form, or
in a report.
 
W

Wayne-I-M

If you post the details of the fields that you wish to base the calculation
on someone will give you the formula.
eg. If
You want to know the date of birth of some one you will need to post the
name of the DateOfBirthField
You want the number items in stock, you will need to post the field name
that you store your sales in and your orginal stock level - also do you want
warning when the stock falls below a certain amount.
etc
etc

It's not too hard to do but you need to give some information to get a good
answer - as much details as you can give would be great
 
T

teelee

I need the Cost of a plan to minus the E Charge then minus the Trip Charge
and I have a Total at the end.

Thanks
 
T

teelee

Yes I have the Query I'm just not sure how to set it up under the criteria.
Do I enter under all the info under all the fields that I mentioned?

Thanks

Wayne-I-M said:
Do you have a query yet?

Result: Nz([TableName]![Cost],0)-(Nz([TableName]![E
Charge],0)+Nz([TableName]![Trip Charge],0))

Have a look at this site
http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033

Good luck

--
Wayne
Manchester, England.



teelee said:
I need the Cost of a plan to minus the E Charge then minus the Trip Charge
and I have a Total at the end.

Thanks
Click to expand...
Click to expand...
 
J

John W. Vinson

I need the Cost of a plan to minus the E Charge then minus the Trip Charge
and I have a Total at the end.
Click to expand...

Teelee, if you're using the Table datasheet to interact with the data...
don't. Tables are for data storage, not for display or editing!

As a result, it does not matter that a table should not - indeed cannot -
contain calculated fields or totals. You're not looking at the table anyway!
Put those calculations on a Form for onscreen display, and/or on a Report for
printing, and use *THOSE* rather than the table.

John W. Vinson [MVP]
 
W

Wayne-I-M

Make sure you can see the table with the data in the space above the grid.

Find an empty column and it the top row (field) paste this.
Result: Nz([TableName]![Cost],0)-(Nz([TableName]![E
Charge],0)+Nz([TableName]![Trip Charge],0))

Then change the "TableName" to the real name of the table
Change (if nes) the field names to what they really are.

Oh - if they are the real names it's a good idea to not have spaces in field
names in a table for a few reasons.




--
Wayne
Manchester, England.



teelee said:
Yes I have the Query I'm just not sure how to set it up under the criteria.
Do I enter under all the info under all the fields that I mentioned?

Thanks

Wayne-I-M said:
Do you have a query yet?

Result: Nz([TableName]![Cost],0)-(Nz([TableName]![E
Charge],0)+Nz([TableName]![Trip Charge],0))

Have a look at this site
http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033

Good luck

--
Wayne
Manchester, England.



teelee said:
I need the Cost of a plan to minus the E Charge then minus the Trip Charge
and I have a Total at the end.

Thanks

:

If you post the details of the fields that you wish to base the calculation
on someone will give you the formula.
eg. If
You want to know the date of birth of some one you will need to post the
name of the DateOfBirthField
You want the number items in stock, you will need to post the field name
that you store your sales in and your orginal stock level - also do you want
warning when the stock falls below a certain amount.
etc
etc

It's not too hard to do but you need to give some information to get a good
answer - as much details as you can give would be great



--
Wayne
Manchester, England.



:

But can I have the calculations showing in the Table? How would I set up the
Query?

Thanks

:

Bad Idea.

If you have a calculation result stored in a table you will end up having
incorrect data.

Store the data only in the table and do the calcuations in a query/form/report

--
Wayne
Manchester, England.



:

Can anyone tell me if there is a way to have a calculated field autopopulate
for a total column in a table? I know this can be done in a report, but I
need to know if it can be done in a table.


Thanks
Click to expand...
Click to expand...
Click to expand...
 
W

Wayne-I-M

ooops - sorry that was not you John (pressed enter by mistake)

Sorry

--
Wayne
Manchester, England.
 
W

Wayne-I-M

il prezzo include : stanza, collazione e cena
il prezzo e di 310 euro a persona tutto incluso (anche le tasse)
sconto di 30% per 3a personase ci saranno tre persone in stanza
sconto di 25% per tutta la stanza se ci saranno 4 persone in stanza
le stanze in disposizione saranno come in lista aggiunta qui sotto
una stanza doppia gratis per per me

--
Wayne
Manchester, England.
 
Top