"... have vast knowledge ... " -- there's a lot of that goin' 'round here
....g

Jeff B.

"hardarch" wrote in message
news
hello kind folks who have vast knowledge...

I have a table of students who are employed by various companies. The
table
has a field where the employer's name is entered. AND I have a separate
table of employer company details. I would like to be able to create a
query
that gives me the student names, their employer's name, and their
employer's
details. The employer's names are entered identically in the fields of
both
tables (ie spelling etc)...

It seems like a simple problem but I just don't seem to be able to figure
out how to do it.. any advice would be great. thank you