Best Practice Question for Calculations on a Report or Query

[Bdaviskar]

Is it more efficent (Best Practice) to do calculations and if then statments on a reprot or form than it would be to include on a query?

I have alot of records that will require a few calculations of fields followed by a nested if then statements I am not sure if I should just wait and do them on the report in a text box or just do in the original query.

Thank you in advance.

 

[plog]

You should try and do all data manipulation in a query. For one, that's the purpose of a query, the purpose of a report is to display data. Second and most importantly, doing it in a query let's you access the data from more than just the report. You can use a Dlookup to get data in it, you can use the query as the basis for other queries--either at an aggregate level or by linking other queries/tables to it.

 

[Bdaviskar]

Thank you!