Best to calc on report or query?

[Stuart Green]

I have a report that is doing quite a lot of calculations, so much so that sometimes it crashes Access. Is it best to do calculations on the report or on the query feeding the report please?

 

[Rich]

How long is a piece of string?
In general terms it's more efficient to do the calculation on the report, although depending on the number of records returned you may not notice any difference.
With the problems your getting it would probably be worth trying to break the calculations down into sub queries