calculating fields

[Joryly]

I am looking to find out how you enter a formula in a field to calculate the
answer, by multiplying one field by another in the same table, I can't find
it in my book? Any suggestions on a really good informative book for Access
would also be helpful, The one I have isn't very good.

 

[George Hepworth]

You are thinking about Excel, aren't you, where you CAN use formulas in
cells to calculate and display values?

Excel and Access are actually different. One of those differences is that
the technique you are describing is not appropriate for Access.

What you can do, if you need to display the calculated value in a report, or
on a form, is create a calculated field in the query which provides the
recordset for the report or form, is to create that calculation as an
additional field in the query and then display it in the report or form.

Another option is to put a control on the report or form and make the
control source for that control the calculation you need.

In any event, there's no need to be putting formulas in table fields.

George

 

[Floydene]

Joryly,

You can add a column to a query and create the calculation in that column.
But you can't calculate within a table, to my knowledge, in Access. You could
export the table to Excel and then make the calculations there.

Floydene