Query to Change Tables

[Apauls]

I input data into a table that looks like this...

ID# Class Mark SpecID
1 Bio 80 A
1 Phy 60 B
1 Math 70 B
1 English 70 A
2 Econ 60 B
2 Chem 50 A
2 Math 70 A
2 English 80 B

..

I would like to select both the classes with a SpecID of "A" for each student,
which I can do with a select Query. But I would like to split them up when
I create a table with them...

ID# Class1 Mark1 Class2 Mark2
1 Bio 80 English 70
2 Math 70 Chem 50
..

Ideas? I would appreciate thoughts on the matter.
Pauls

 

[John W. Vinson]

I input data into a table that looks like this...

ID# Class Mark SpecID
1 Bio 80 A
1 Phy 60 B
1 Math 70 B
1 English 70 A
2 Econ 60 B
2 Chem 50 A
2 Math 70 A
2 English 80 B

.

I would like to select both the classes with a SpecID of "A" for each student,
which I can do with a select Query. But I would like to split them up when
I create a table with them...

ID# Class1 Mark1 Class2 Mark2
1 Bio 80 English 70
2 Math 70 Chem 50
.

Ideas? I would appreciate thoughts on the matter.
Pauls

It sounds like you're actually trying to create a REPORT, not a table. This
proposed table would be grossly denormalized, with repeating fields and no
defined width (i.e. one student working part-time might have a record with
five fields - one ID, two classes, two marks - and a greasy grind taking eight
classes would have 17 fields).

You can construct a *recordset* displaying data in this way - with some
difficulty; but it would be a Very Bad Idea to create a table like this.