How do I Find and Replace blanks with $0.00

[MySki]

I am currently revising an existing database. The database has 14,929 records. Originally, the database had one field for total cost. The program managers now want a field for primary cost, seconary cost and update cost. Then then want a total of all these costs.

I have created a calculation to obtain the total cost of the three fields which works fine on new records. I have also set the default to $0.00. However, the three new fields are currently blank on all 14,929 records that were previously in the database. Since the records are not new, the default $0.00 will not show up. Since there is no number in the field, it does not work in my calculation.

Is there any way to automatically replace all blanks with $0.00 without physically typing this into all records?

Any help would be great...thanks!

 

[jon92]

See
thread707-560925

The 2nd reply from jebry should help you

cheers

 

[MySki]

jon92. I tried adding the second field as you suggested above from the earlier thread. Where do the words Don't Show go??

Also, should I create a separate table with a zero in the UPDATECOST field to make the table change the empty cells to the defautl ($0.00).

Any additional help would be great...thanks

 

[jon92]

Sorry to confuse you! the 'Don't Show' part of the thread refers to another type of query.
You need an update query.

 

[MySki]

Used the update query and it worked great! Thanks for your help