AMCTRNo: IIf(IIf(IsNull([AM_CTRNo2]),0,[AM_CTRNo2]) > 0,IIf(IsNull([AM_CTRNo2]),0,[AM_CTRNo2]),"000000000")
torres0157 <[EMAIL PROTECTED]> wrote:
torres0157 <[EMAIL PROTECTED]> wrote:
Hello
can someone help me with my _expression_.
AMCTRNo2: IIf(IsNull([AM_CTRNo2]),0,[AM_CTRNo2])
This works fine but I need the calculated field formatted to 9
zeroes if the field is null. I tried various expressions but non
seem to work. some expressions I tried are:
AMCTRNo: IIf(IsNull([AM_CTRNo2])>0,Format([AM_CTRNo2]+0,0),"000000000")
AMCTRNo: Format([AM_CTRNo2]+0,"000000000")
can someone help
Thanks
A.T.
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
Yahoo! FareChase - Search multiple travel sites in one click.
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
