Updating from Many records to one table

[Guest]

I have a 2 tables. I want data from the second table to roll up into a unique
record in the first based on UniqueNo. I am assuming an Update query is my
best bet. I am not skilled in SQL or VB and was hoping using the QBE grid
would be doable.

Please see below:
Table1 (One)-

UniqueNo
course1
course2
course3
date1
date2
date3

Table2 (Many)-

UniqueNo
course
date

TIA,
Lyric

 

[Jeff Boyce]

Is it your intent to end up with the same data in two tables?

Or are you trying to summarize data from a "many" side table?

Neither of these is generally necessary, nor a good idea.

Your Table1 has "repeating fields" (course1, course2, ...). While this is a
necessary design if you are using a spreadsheet, you will NOT get the
benefits that Access offers if you try to make an Access table work like a
spreadsheet.

More info, please...

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

My intent is to roll up multilple rows per Table2.UniqueNo into one row per
Table1.UniqueNo. So, if there are 2 records with course and date data in
table2 for UniqueNo 003, I want the first course for Table2.UniqueNo 003 to
go to Table1.Course1 and the first date to go to Table1.date1, the second
course for Table2.UniqueNo 003 to go to Table1.Course2 ane the second date to
go to Table1.date2 and so on. Yes, it would be the same data in both tables.
Table1 would be one record per indivdual which is my desired result.

 

[John Vinson]

Table1 would be one record per indivdual which is my desired result.

Table1 should not exist. Instead, use a Crosstab Query to *display*
the properly normalized data in this spreadsheet format.

John W. Vinson[MVP]