Update data in one table from data in another another

[terre]

I have two tables, essentially with the same data.....but

tblA
StudentID OutcomeID Acheived
1 1.1 Yes
1 1.2 No
1 1.3 Yes
etc

tblB
StudentID 11 12 13
1 y n n

Is it possible to write an update query to update tblB from tblA, especially given the "1.1" to "11" change that is needed?

 

[AlexCuse]

I think your database might be in need of a redesign.

As this is not always possible, you could probably do this using VBA butI am not sure it would be worth the trouble. What are all of your possible outcomeID's?

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[terre]

I was afraid someone might say that


OutcomeID
1.1
.
.
.
1.13
2.1
.
.
.
2.13
3.1
.
.
.
.
.
.
3.13

Theres a few

but If I need to redesign....

Terre