Thanks James and Don. Your solution is so elegant and easy. LEN...I had not clue what it was for. Lesson learned. /gl -----Original Message----- From: James LaBorde [mailto:jlaborde@xxxxxxxxx] Sent: Monday, October 21, 2002 4:59 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Glenda, This is possible in Access. You have it pretty much set for the left side but you will probably need to change your number to 5. As for the second half of your equation: Zip4: IIF(len([zip])=10, Right([zip],4),"0000") I am assuming you have your field set to text. If you are not entering the hyphen in these then you will need to change your equation to =9. If you need any more help just holler. James La Borde South Western Federal Credit Union P.S. Linda, how can you bash Access, it can do anything Excel can as long as you know how to make it. And it doesn't have that extremely annoying limitation of 65536 rows. -----Original Message----- From: Glenda Wells [mailto:gwells@xxxxxxxxxxx] Sent: Monday, October 21, 2002 1:39 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access :VSMail MX2 Thanks. Have fun. /gl -----Original Message----- From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx] Sent: Monday, October 21, 2002 4:36 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Access OH... I see....that's something Excel can do easily too (good ol' Text to columns) Up with Excel....down with Access!!! LOL Hopefully one of our Access gurus will be along to help you, shortly. Actually....I'm heading out the door to teach my Access class at the college now (LOL)....thank GOD they don't ask me to teach advanced Access....I'm good at the basics in Access, but when it comes to the rest of it, I am el stinko!! Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells Sent: Monday, October 21, 2002 4:28 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Access Access has a right function which I can use and it works on a zip of 32724-1234 but for a zip of just 32721, the second column becomes 2721 instead of the 0000 that I need. I can't figure out how to tell it to do the right function only if the zip code is longer than 5 characters. pffffhhhmmmph! /gl ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************