[mso] Re: Access
- From: Don L Elias <donelias@xxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 21 Oct 2002 20:26:13 -0500
Well, if he had been looking for a way to do it in Excel my
method would have been okay. Duh!!!!!!!!!!!!
I will have to learn to read FIRST.
Maybe you could combine Dian's wisdom with my hacking
by copying it into an Excel file and doing what I said.
Don Elias
On Mon, 21 Oct 2002 15:07:01 -0500 "Dian Chapman" <dian@xxxxxxxxxxxxx>
writes:
>
> Well...I'm SURE there's some special way to do this in Access...but I
> always cheat and just convert the data in Word. I just took your sample
> and in 2 seconds, converted it into two fields in an Access Table.
>
> I just captured your data, which you can do by highlighting the column
> and hitting Ctrl/C...open Word and dump it into a blank Word doc. Hit
> Alt/E/E to Search/Replace. Enter - hyphen to search and ^t as a tab
> to
> replace. Now hit Ctrl/A to select all again, open your table. Be sure
> you've entered a new, blank field for the second info and have them
next
> to each other. Highlight both fields and hit Ctrl/V to paste. Access
> knows the tab is the second field. The Zip goes into the first field
and
> the extension goes in the next.
>
> It works quick and easy. Granted...I do this all the time so I have a
> macro that converts it for me. Note also, if you pull the data from
> Access (whereas I did right from your email), the data will first be
> dumped into a table. So you just select the table and click
> Table/Convert table to text.
>
> Good luck!
>
>
> Dian Chapman
> Technical Consultant, Instructor,
> Microsoft MVP & TechTrax Editor
>
> Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
> Tutorial web site: http://www.mousetrax.com/techpage.html
> TechTrax Ezine: http://www.mousetrax.com/techtrax/
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Glenda Wells
> Sent: Monday, October 21, 2002 3:03 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Access
>
>
> I should probably know this already but...
>
> I have a text field that contains zip codes like this:
> 32724
> 32720-1234
> 32723
> 32724-0000
>
> I need to separate the zip codes into two columns like this:
> Zip Extn
> 32724 0000
> 32720 1234
> 32723 0000
> 32724 0000
>
> I'm having a fit trying to figure it out. I can get the first column
> easily enough using Left([Zip], 4) but I can't get the second
> column.
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/web/.
*************************************************************
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
*************************************************************
Other related posts:
