G
Guest
Stumped at this point. I have linked to a table that I cannot update but I
need to update a checkbox in my query based on information in the linked
table.
My fields
Program Num (text), Week End Date (date record was entered), and SignedOff
(checkbox).
If that particular program num comes up again in the future, I need to
update the signedoff checkbox to yes.
I have tried an update query and a setvalue macro, using a conditional If
(iif [Week End Date]>=[Week End Date] then....) but can't really query the
field on itself?
Am I making this more difficult than it is?
need to update a checkbox in my query based on information in the linked
table.
My fields
Program Num (text), Week End Date (date record was entered), and SignedOff
(checkbox).
If that particular program num comes up again in the future, I need to
update the signedoff checkbox to yes.
I have tried an update query and a setvalue macro, using a conditional If
(iif [Week End Date]>=[Week End Date] then....) but can't really query the
field on itself?
Am I making this more difficult than it is?