Update Query

[Guest]

Hello,

I have two fields (Student Name and Homework Type) in Table A. Table A may
contain more than one homework type per student. There are 4 different
homework types.

I also have Table B. Table B contains 5 fields (Student Name and 4 Homework
Types).

What I want to do is I want to know what types of homework each student do
in Table B by having X under each homework type column. I use Update query,
and it doesn't come out correctly.

For example, if I filter Homework Type 1 in Table A, I get 200 records. On
the other hand, I get only 150 records with X's in Table B.

In my Update query, I do Inner Join between Table A and Table B on Student.
Then I write this formula 'iif(Table A!Homework Type="1","X","")' next to the
Update To field for each type of homework.

Can someone help me why Table B does not come out correctly?

Thanks.

 

[Guest]

Good morning,

I posted the below problem last week. I have not heard anything from
anyone. Can someone please help me with the problem? I don't understand why
the update query would not populate correctly.

Thanks.

 

[David Cox]

can you go to SQL view and copy the SQL to this newsgroup.