formulas in a table

  • Thread starter Thread starter Guest
  • Start date Start date
Whatever your question is, I think the answer is "no".

You can display something like this in a query.
TwoPlusTwo: 2+2
 
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
(e-mail address removed)> wrote in message
Can you enter a simple sum formula in a cell of a table? For example:
Click to expand...
=2+2
 
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.
 
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.
 
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
 
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
(e-mail address removed)> 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...
 
Back
Top