Adding a "-" (dash) as a default value in table

[virblitz]

Greetings,

I currently have a very basic table/query/report set up to calculate monthly revenue. The data type in my table fields are "Currency" and my existing default value is "0".

I would like to change the "0" default value to a "-" (dash) for non existing values and still be able to calculate totals.

How do I incorporate this dash line and still be able to calculate figures??

Thanks in advance for your time and consideration!!

-virblitz

 

[andrew93]

Hi
You could set your field format to something like this:
$#,##0.00 ; [Red]-$#,##0.00 ; - ; -
It will give a dash for zero values, and I believe it gives a dash for null values too (albeit slightly out of alignment?)
HTH, Andrew