Good Morning, I am creating a table that will be exported and a field that is input into the query needs to be formated to 9 zeroes if the field contains zeroes or spaces. I used the following format expression but only one zero is placed in the destination field. if the input field in the table (AM_CTRNo3) does not contain valid data. AMCTRNo3: IIf(IsNull([AM_CTRNo3]),0,[AM_CTRNo3]) can someone help
Thanks A.T. ------------------------ 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/
