Updating table based on another table

[Tabby]

OK...Have another question.......

I have a table Members, which has ID# as the unique id.
Then I have a table Contributions, where all
contributions are entered for all members, only enter
ID#, depositdate, depositamount, appeal, code.

Each contribution gets labeled with a code, such as g for
general, s for special project.

I want to update the Members table columns: YR03 for all
deposits labeled g, and SP03 for all deposits labeled s
for the each member.

How do I write that string? Any help is greatly
appreciated! Thanks!

 

[Steve Schapel]

Tabby,

Normally this would not really be a recommended thing to do. Not in a
database, anyway. When you think about it, it amounts to storing the
same information twice in two different places. For your requirements
of form or report, you will always be able to find the YR and SP
values for any menber(s) by way of a simple query on the Contributions
data. Maybe it would help if you could say a little more about the
field where you want to put this YR03/SP03 value, what it means, and
why you want it, and someone may be able to help further.

By the way, as regards your ID# field, it is not a good idea to use a
# as part of the name of a field or database object.

- Steve Schapel, Microsoft Access MVP