Microsoft Access Update Query Error

[RAB1645]

When trying to update a table with new values using an update query I get an error message "Operation must use an updatable query". I read that you cant update a table using an update query on a one-to-many relationship. WHY NOT !?? Is there no other way to do this ??

I want to update membership fees in a table. I have one table with 2 fields. Account# and number of family members. The current values in the fee table should be updated by the number of family members X the fee for each member.

Please help.

 

[Dreamboat]

Cause you can't update with a calc. I think you want a make-table query. Go ahead and let it make a table exactly like your existing, then remove the old one, rename the new one to the old one's name.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com