By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,747 Members | 1,345 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,747 IT Pros & Developers. It's quick & easy.

addresses

P: n/a
Guys, I have a listing of names and addresses:

Line 1 - name
Line 2 - street
Line 3 - area
Line 4 - town
Line 5 - town
Line 6 - post code
Line 7 - null
Line 8 - name
Line 9 - street
....etc...

All in one column in a table. I need to make address labels for these - one
thought is to have a bit of code that deletes all rows, except the 8th row,
to just leave the names - I could then copy the names to a new table column
called 'names', then repeat for the 9th row 'street', 10th row 'area' etc..?

Any help would be much appreciated as always.

Thanks,
Lap
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
"Lapchien" <no**@m.com> wrote in message news:<10***************@ananke.eclipse.net.uk>...
Guys, I have a listing of names and addresses:

Line 1 - name
Line 2 - street
Line 3 - area
Line 4 - town
Line 5 - town
Line 6 - post code
Line 7 - null
Line 8 - name
Line 9 - street
...etc...

All in one column in a table. I need to make address labels for these - one
thought is to have a bit of code that deletes all rows, except the 8th row,
to just leave the names - I could then copy the names to a new table column
called 'names', then repeat for the 9th row 'street', 10th row 'area' etc..?

Any help would be much appreciated as always.

Thanks,
Lap


Never tried it, but you might be able to open the table as a recordset
and then use the Split function and then populate fields in your table
with the elements of the array the Split function creates.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.