Question: Calculated data on forms/reports

[Veli Izzet]

Hi,

I want some calculated data to be present on some forms and reports. Is
it a better practice to create a query that holds these expressions and
put them on the form/report, or would it be better is I use the table
itself and make the calculations when displaying the form/report.

Thanks for answers,
Veli Izzet

 

[Dirk Goldgar]

Hi,

I want some calculated data to be present on some forms and reports.
Is it a better practice to create a query that holds these
expressions and put them on the form/report, or would it be better is
I use the table itself and make the calculations when displaying the
form/report.

I don't know if it makes much difference whether the calculations are
performed by the query or by controlsource expressions on the form or
report. If the calculation is based solely on the values of fields in
the table, and especially if it's a calculation that is frequently
needed, I'd be inclined to make it in a query, and use that query as the
basis for both forms and reports.