AOB
Registered User.
- Local time
- Today, 10:03
- Joined
- Sep 26, 2012
- Messages
- 620
I have a textbox control that displays the number of workdays between two dates. I am using a custom format to suffix " days" after the number for clarity :
#,##0" days";[Red]#,##0" days"
I'd like to modify this so that when the value is 1, it displays "1 day" rather than "1 days"
Tried using this :
[=1]0" day";#,##0" days";[Red]#,##0" days"
But it's not liking it (appears like this)
[=1]7 day
Any idea how to appropriately customise a number format with conditions? (Fully admit I'm nicking the custom format from Excel rather than Access so suspect the issue is that Access only likes [Positive];[Negative];[Zero];[Text] but hoping there is some way to specify conditions in a similar manner?
Thanks!
AOB
#,##0" days";[Red]#,##0" days"
I'd like to modify this so that when the value is 1, it displays "1 day" rather than "1 days"
Tried using this :
[=1]0" day";#,##0" days";[Red]#,##0" days"
But it's not liking it (appears like this)
[=1]7 day
Any idea how to appropriately customise a number format with conditions? (Fully admit I'm nicking the custom format from Excel rather than Access so suspect the issue is that Access only likes [Positive];[Negative];[Zero];[Text] but hoping there is some way to specify conditions in a similar manner?
Thanks!
AOB