CHANGEING BLANK FIELDS TO 0

  • Thread starter Thread starter AMDGUY [MCP]
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

more or less than 0 or blank 3
text field to checkbox on imported excel sheet 2
Formula than understands midnight? 25
Adding Data to a blank "Template Table" 7
Change blanks to 0 (zero) 5
Can Vba workout if a selection is part of a group? 0
insert 0 instead of blank field importing from Excel 5
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top