Greetings!

In general, is it best to base reports on stored queried developed specifically for a report or to create a SQL statement within the report (same query but not stored as a seperate object).

Also, are calculated fields best done in a query or in an unbound control on a report?

These questions are to help facilitate optimum speed and performance.

Thanks.

In general, a stored query is a more efficient RecordSource for a report than is an inline SQL statement. The "Jet" engine optimizes queries when you save them.

I am sure there are exceptions for some types of complex queries.

Calculations are also beter done in a query than with formulae in text boxes.

RichM

Calculations are best done on a form or in a report, not in a query.