Lonnie, Thanks for the help but this query has errors. A.T.
--- In AccessDevelopers@yahoogroups.com, Lonnie Johnson <[EMAIL PROTECTED]> wrote: > > AMCTRNo: IIf(IIf(IsNull([AM_CTRNo2]),0,[AM_CTRNo2]) > 0,IIf(IsNull ([AM_CTRNo2]),0,[AM_CTRNo2]),"000000000") > > > 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. > > > > > > > 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. > > > --------------------------------- > > > > > > > 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. > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
