P
PJ
I want a field to show $0.00 if it is not numeric. Is this possible?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Spencer
Use a calculated field as follows:
IIF(IsNumeric([SomeField]),[SomeField],"$0.00")
I'm assuming that the field is a text field that shows values like $124.09,
Unknown, N/A, etc.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
IIF(IsNumeric([SomeField]),[SomeField],"$0.00")
I'm assuming that the field is a text field that shows values like $124.09,
Unknown, N/A, etc.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
K
KARL DEWEY
Try this --
MyField: Format([YourField], "$0.00")
MyField: Format([YourField], "$0.00")
K
KARL DEWEY
Try this --
MyField: Format([YourField], "$0.00")
MyField: Format([YourField], "$0.00")
J
Jeff Boyce
?!
You have a field that can store numbers or not-numbers? That doesn't sound
very well normalized...
Regards
Jeff Boyce
Microsoft Office/Access MVP
You have a field that can store numbers or not-numbers? That doesn't sound
very well normalized...
Regards
Jeff Boyce
Microsoft Office/Access MVP