Queries and Report Optimization Question

C

cefrancke

Which is typically faster or preferred...

Let the query do the calculated fields or the report?

Join tables and let the query lookup the fields or only include the
lookup table ID's (foreign keys in master table) and let the report
lookup the values in combo boxes?


TIA
 
D

Douglas J. Steele

I don't believe there's much of a difference between doing the calculations
in the query or in the report. I typically do them in the query, because I
can then use the query elsewhere if I need to, and be sure of the same
calculations.

I definitely wouldn't put combo boxes on a report: that's pointless, since
combo boxes are meant for interaction, and you can't interact on a report.
 
Top