formulas in a table

  • Thread starter formulas in table cells.
  • Start date
F

formulas in table cells.

Can you enter a simple sum formula in a cell of a table? For example: =2+2
 
D

Duane Hookom

Whatever your question is, I think the answer is "no".

You can display something like this in a query.
TwoPlusTwo: 2+2
 
R

Rick B

You do not store calculated values in a tabel. That would be redundant if
you already have the data needed to perform the calculation stored. What
happens if you change value one later? How does the table know to update
the SUM? Would you really want it to recalculate all these values every
time you open your table?

This should be done in the form or report using an unbound text box...

=[field1] + [Fiedl2]


or as a caluculated field in a query...


SumOfFields: [Field1] + [Field2]



Rick B


"formulas in table cells." <formulas in table
[email protected]> wrote in message
Can you enter a simple sum formula in a cell of a table? For example:
Click to expand...
=2+2
 
G

Guest

hi,
access is not excel. what you are trying to do is an excel
thing. you can put forumlas in a query and they are
entered at a header and do the calculations on the records
but you cannot put a fourmla in a table.
 
M

Monica

Thanks. Unfortunately I'm trying to eliminate some "double entry" work on my
end by not using excel. The data that I am working with is already in Access
and just though if I could keep track of "fees" added to a client one cell it
would be easier.
 
G

gls858

Monica said:
Thanks. Unfortunately I'm trying to eliminate some "double entry" work on my
end by not using excel. The data that I am working with is already in Access
and just though if I could keep track of "fees" added to a client one cell it
would be easier.

:
Click to expand...
Like I said before, explain what you are trying to do and I'm sure
someone here will help. It may as simple as adding a new field to a table.

gls858
 
K

kul

Thanks Rick B,

I always wonder how the calculation works in Access as I normally use Excel
for calculations. Your suggestion on having an unbound box at the report
works excellent at the report I'm working at. Thanks...

kul

Rick B said:
You do not store calculated values in a tabel. That would be redundant if
you already have the data needed to perform the calculation stored. What
happens if you change value one later? How does the table know to update
the SUM? Would you really want it to recalculate all these values every
time you open your table?

This should be done in the form or report using an unbound text box...

=[field1] + [Fiedl2]


or as a caluculated field in a query...


SumOfFields: [Field1] + [Field2]



Rick B


"formulas in table cells." <formulas in table
[email protected]> wrote in message
Can you enter a simple sum formula in a cell of a table? For example:
Click to expand...
=2+2
Click to expand...
 
Top