Report & Layout View different from Print Preview

[jcrist30]

:banghead:

I have a report based on a query and containing several of its fields in addition so some other controls. There are several calculations being made on the report, and when I view the report in Layout or Report View, everything populates and calculates correctly. However, when I switch to print preview, one of my base fields, which acts as the denominator for the value of another field, suddenly populates with "0.00", naturally causing the dependent field to read "#Div0!".


Any help/insight would be greatly appreciated.

 

[Trevor G]

Welcome to the forum,

It would be useful to see the database, to look at the field in the report which is causing the issue. Would you be able to strip down a version and upload it?

In case this is the cause, have you checked to see if the field is in the Detail or Page Footer or Report Footer?

 

[vbaInet]

Or if it's not possible to upload a version, let's see the calculations.