I have two worksheets in same workbook. W1 has student ID and other stuff
about students, W2 has addresses for these students.
I want to know if there is an easy/straightforward way to join these.
I have previously done this using the join table function in Access but am
writing procedures for someone else to follow and am looking for a less
clumsy way to do this.
nb: There are some multiple addresses for students and some students dont
have a known address.

Purp,

The join is usually accomplished in Excel with a VLOOKUP for each field. But I'm not sure
why you have student names in one table and student addresses in another. You'd not
normally do that in Access either, unless maybe there's confidential stuff in one table or
the other. Maybe we need to know more. At any rate, the VLOOKUP can find the row you want
(the lookup colum must be on the left of the cell to be retrieved, and the values must be
unique). You may have to give us an example of how your data is laid out.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"PurpleMel" wrote in message
...
I have two worksheets in same workbook. W1 has student ID and other stuff
about students, W2 has addresses for these students.
I want to know if there is an easy/straightforward way to join these.
I have previously done this using the join table function in Access but am
writing procedures for someone else to follow and am looking for a less
clumsy way to do this.
nb: There are some multiple addresses for students and some students dont
have a known address.

Hi Earl

Thanks for the response. I will go away and have a play with VLOOKUP to see
if it less clumsy than the way I have been doing it up till now.

FYI: The data was supplied by a different dept of the University and the
worksheet contains student ID, sex, college, course, etc on one sheet (but
without addresses) and almost the same again (but with addresses) on another
sheet.

I think maybe I will go and visit Student Services and see if I can get them
to provide the data exactly how I need it for next time.

Thanks once again for your advise.

Purp!

"Earl Kiosterud" wrote:

Purp,

The join is usually accomplished in Excel with a VLOOKUP for each field. But I'm not sure
why you have student names in one table and student addresses in another. You'd not
normally do that in Access either, unless maybe there's confidential stuff in one table or
the other. Maybe we need to know more. At any rate, the VLOOKUP can find the row you want
(the lookup colum must be on the left of the cell to be retrieved, and the values must be
unique). You may have to give us an example of how your data is laid out.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"PurpleMel" wrote in message
...
I have two worksheets in same workbook. W1 has student ID and other stuff
about students, W2 has addresses for these students.
I want to know if there is an easy/straightforward way to join these.
I have previously done this using the join table function in Access but am
writing procedures for someone else to follow and am looking for a less
clumsy way to do this.
nb: There are some multiple addresses for students and some students dont
have a known address.

On 6 Giu, 15:24, PurpleMel
wrote:
I have two worksheets in same workbook. W1 has student ID and other stuff
about students, W2 has addresses for these students.
I want to know if there is an easy/straightforward way to join these.
I have previously done this using the join table function inAccessbut am
writing procedures for someone else to follow and am looking for a less
clumsy way to do this.
nb: There are some multiple addresses for students and some students dont
have a known address.

Try this one:

DataTime Documentation
http://cam70.sta.uniroma1.it/DataTimeDocumentation/

DataTime Universal (downloadable)
http://cam70.sta.uniroma1.it/DataTimeUniversal/