Do Calculation In Form Or Query (1 Viewer)

[AJR]

Hi

General question.

If I want to populate a text box in a form, whose RecordSource is a query, with the result of a calculation.

For example:

Query Fields are [Quantity] and [Price] and I want the form to show [Quantity], [Price] and [TotalPrice].

Does it make any difference if I put an expression in the Query to arrive at [TotalPrice] or do it in the form?

If so, which is better?

Thanks

A/R

 

[RuralGuy]

It probably does not make a difference but I prefer to do my calculations in the query. It *would* make a difference if you are using a static query since they will do some strategy in advance of running the query so there will be a perhaps slight speed difference.

 

[pbaldy]

I agree with RG. Two more advantages: it can force the processing to the server, and it allows you to sum the calculated field easily in forms and reports.