Whish is faster? - Calculated field in QUERY or Calculated field in REPORT? (1 Viewer)

Cosmos75

Registered User.

Local time

Today, 16:22

Joined

Apr 22, 2002

Messages

1,281

• Mar 17, 2003

• #1

Whish is faster?

1) Having calculated fields in a QUERY?

2) Having calculated field in REPORT?

3) Depends?

I've always used queries to calculate formulas and reports to create summaries of the formulas (Total, Average, MAX and what have you).

Is there a rule of thumb regarding when to have the calculated fields in a query and when to have them in a report?

 

K

KevinM

Registered User.

Local time

Today, 22:22

Joined

Jun 15, 2000

Messages

719

• Mar 17, 2003

• #2

Would have thoughts queries are faster as reports have an extra 'layer' to process, the fomatting of the report as well as the running the underlying recordset.

Also definatley more useful to calculate in queries. That way they can be used (and often are) throughout the db rather than viewd in just one report.

 

Last edited: Mar 18, 2003

R

Rich

Guest

• Mar 18, 2003

• #3

Depends what you mean by faster and the size of the underlying recordset, complexity of the calculations.
If there are a large number of records moving the calculated fields to the report/form will make the report/form open faster, the query has to calculate all the records before it can open.


There are certain types of calculation which are better done at form/report level anyway.

 

Cosmos75

Registered User.

Local time

Today, 16:22

Joined

Apr 22, 2002

Messages

1,281

• Mar 18, 2003

• #4

There are certain types of calculation which are better done at form/report level anyway.

Click to expand...

Rich,

What kind of calculations are better performed on a report? Do you mean SUM, AVG, MIN and MAX?

If there are a large number of records moving the calculated fields to the report/form will make the report/form open faster, the query has to calculate all the records before it can open.

Click to expand...

What about things like Mutliplication, Division, Addition and Subtraction at the individual query record level? Are those better left in the query or report?