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. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
