Fill null fields with 0

Dear Kate

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Like Forms Reports are normally created from existing Tables or Queries.

If you want to update the reports you have to amend the data in the source table or query.

Let's assume that there was a field called "Qty ordered" which was in a table called "Orders" and it had lots of blank cells (or data value). You have already created a report called "Orders Report" based on this table. You want to replace the blank cells with 0.

Please follow these steps:

Close the report

Open the Orders Table

Click anywhere on the "Qty ordered" field

Choose CTRL +H ( or Edit Replace)

In teh Find What box Type in NULL

In teh Replace with Type 0

Choose Replace All

A message will appear warning you that you cannot undo this action if you press Yes.

Press Yes.

All teh Null values will be replaced with 0.

If you open the "Orders report" you will see that the values would have been updated.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT