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 *************************************************************