Update Query suddenly not working!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pretty green, but here goes.

I have been using an Update query to make the number value in column "B" the
same as Column "A" after a specified amount of time has passed without column
"C" being resolved. All columns are from the same table. It has worked fine
until recently. I compared it with a backup copy of the query and discovered
that the table name in the "Update to" portion was listed as: Table![Column
B] while in the current (non-functioning) query the table name is listed as:
![Column B]
I tried deleting the brackets but it just puts them back up. And I need to
get this working PRONTO

Please help,
Thanks,
Tim
 
I believe I have solved the problem myself, I simply created a new query,
verified that the all the fields had the same Date format, and Table![Column
A]*1 in "Update To"

Can somebody explain how the frontend/backend using two databases works?

Thanks all,

Tim K
 
Back
Top