CHANGEING BLANK FIELDS TO 0

A

AMDGUY [MCP]

I imported an excel spread sheet in to on access table.
All the calculations in my reports are not working b/c the blank fields
do not have 0 in them
is there an easy way to change all theses to 0 b/c there are far to many
records to change
 
V

Van T. Dinh

My guess is that they are Null.

In this case, simply replace YourField with the calculated Field

FieldNullToZero: Nz([YourField], 0)

in the Queries being used as the RecordSource for the Reports and bound your
Controls to the FieldNullToZero instead of YourField..

Check Access VB Help on the Nz() function.
 
Top