formulas in a table

[Guest]

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

 

[Duane Hookom]

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

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

 

[gls858]

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

No. What exactly are you trying to do?

gls858

 

[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
(e-mail address removed)> wrote in message

Can you enter a simple sum formula in a cell of a table? For example:

=2+2

 

[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.

 

[Guest]

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.

 

[gls858]

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.

:

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

 

[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

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:

=2+2