Kelly said:
I need to put calculations into a form so that it will add feilds together. I
can't find how to do this in the form information only in querys. If I set it
up there will it affect my form? I hope Im asking the the question
correctlly, I'm very new (self taught) to Access.
You can do this either way. I'm inclined to think that it's better to
do all the arithmetic you can in the underlying query as it seems to me
that it's easier to understand that way.
I have a billing system which (for example) has one table which stores
price and quantity. I multiply them in a query to produce a "cost"
field, and have a text box on my forms/reports which displays this value.
However, you can set the "control source" of a control (a text box is
one example of a control) to an expression based on any of the fields
which are available from the "record source" of the form or report.
It's very common to have a text box in a footer (group footer, page
footer or report footer) whose control source is: = Sum([field of
interest]) for example.
It's worth fooling around with the "expression builder", which is a
wizard which helps you put together expressions using fields and
functions. Bit of a struggle at first, but it repays study.
Does that help? Or should I have waited for the clearer head that the
morning will surely bring?
Phil, London
