How do I set a default value of $0.00?

[Guest]

I am having a problem with setting the default value of "$0.00" be
automatically populated in my queries. In the Table Design I've added a Field
Name = to "Feb06" with a Data Type = to "Currency". On the general tab I put
"$0.00" for the Default Value row. I go back into the query design and pull
down the month. Open the query and the month Feb06 is there but does not have
any $0.00 displayed in any of the rows. Any assistance would be appreciated!
Thank you!

 

[Rick B]

Ummm. Generally, you should not have data in a field name. A filed name of
"Feb06" is great for a spreadsheet, but no so for a database. Sounds like
you are trying to "commit spreadsheet" as one of our MVPs often says.

You need to step back and reexamine your database structure and consider
normalizing it.

Now, in regards to your question, if the field is a number (currency) then
the default is "0" which (I believe) does not display in the query. I think
you can change the "FORMAT" in your forms and reports to allow zero-values
to actually display.

 

[Guest]

I'll add to what Rick B said. The default value will only be added to new
records. If you have existing data that is null and want it to be 0, you need
to write an update query to do this.