Update Query Problem

[Guest]

Hi all;

I have 2 tables. One main table (lets call it A), one table that has information that needs to go into the main (B). Following the advice of some people on this message board, I started making an update query. First, I created a select query with the fields that I wanted updated in the main table. I then made it into an update query. I added .[fieldname] to the "Update To" field, for each of the fields that needed updating. When I look at the results from the query, I just have a bunch of empty rows where there should be data. What did I do wrong?

Help!

 

[Guest]

What you did sounds correct. In an Update query you will see the fields that are going to be updated, not the result of the update. It is a trust thing. When in doubt, have a backup of your table because you cannot undo.