Access Update Query

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

I have a query that reports records from Table1 that do not match a record
in Table2. I need to be able to enter a value in Table3 based on the
results of this query into this Table3. I've successfully built a form for
this, but i cant figure out how to get the data from this query and the
updated field into another table so I can report that data.

Any ideas?

Thanks
 
I have a query that reports records from Table1 that do not match a record
in Table2. I need to be able to enter a value in Table3 based on the
results of this query into this Table3. I've successfully built a form for
this, but i cant figure out how to get the data from this query and the
updated field into another table so I can report that data.
Click to expand...

An Update query updates the values of fields in existing records. It sounds
like you're trying to *add a new record* - which requires an Append query
instead.

Why do you feel that you need to store this information redundantly in a third
table? What are you trying to accomplish, in a real-world sense? Could you not
base the Form *on the unmatched query itself*? You don't need to have a Table
as the recordsource for a form!

John W. Vinson [MVP]
 
Back
Top