Data linking for mulitple information

[Guest]

In access, i have a table that needs to retrieve information about students
using their SS# as the thread. I need a way to pull mulitiple information
about that student from excel (which I've already linked). The problem I'm
having is there are 5 classes I have to pull info on for a Transcript but, on
each class there is a 'grade' 'hours' start date' and 'end date' column. How
do I import this info into a transcript. I'm using the 'report' for
transcript. This may sound confusing but the trouble lies with gathering all
that info and tieing it into my transcript with the other data that already
exists. please note that on my transcript already designed has the following
fields but not for each class, just "General" Each class is defined by a 4
letter code that references into my transcript.

 

[John Vinson]

On Thu, 13 Oct 2005 09:00:04 -0700, ryan e <ryan

In access, i have a table that needs to retrieve information about students
using their SS# as the thread. I

Clarification: Tables don't *retrieve* information. They *store*
information. You would use a Query (possibly a query joining multiple
tables) in order to retrieve information.

need a way to pull mulitiple information
about that student from excel (which I've already linked). The problem I'm
having is there are 5 classes I have to pull info on for a Transcript but, on
each class there is a 'grade' 'hours' start date' and 'end date' column. How
do I import this info into a transcript. I'm using the 'report' for
transcript. This may sound confusing but the trouble lies with gathering all
that info and tieing it into my transcript with the other data that already
exists. please note that on my transcript already designed has the following
fields but not for each class, just "General" Each class is defined by a 4
letter code that references into my transcript.

And this is completely perplexing. It sounds like you're designing
your database backwards, from the point of view of the transcript
(which should just be a report based on Queries selecting data from
your tables).

What is the structure of your Tables (or your spreadsheets)? How are
the different classes stored - a separate table (spreadsheet) for
each?

John W. Vinson[MVP]