Conditional update of field based on the same field in previous re

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
If that particular program num comes up again in the future, I need to
update the signedoff checkbox to yes.
What do you mean when you say 'comes up again in the future'?
 
Each time I work with that program num I have to log it as a seperate record,
for record keeping purposes. I track each event for that program. I can
have anywhere from 1 to 20 events for that program, If all went as planned it
could get signed off the first time through, but then again it may not get
signed off until the last event. Our level of quality checking goes down
drastically once the program is signed off so that event needs to be noted
for possible future events.


KARL DEWEY said:
update the signedoff checkbox to yes.
What do you mean when you say 'comes up again in the future'?

--
KARL DEWEY
Build a little - Test a little


jeremiah said:
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?
Click to expand...
Click to expand...
 
You need something that relates it back to the event records.
--
KARL DEWEY
Build a little - Test a little


jeremiah said:
Each time I work with that program num I have to log it as a seperate record,
for record keeping purposes. I track each event for that program. I can
have anywhere from 1 to 20 events for that program, If all went as planned it
could get signed off the first time through, but then again it may not get
signed off until the last event. Our level of quality checking goes down
drastically once the program is signed off so that event needs to be noted
for possible future events.


KARL DEWEY said:
If that particular program num comes up again in the future, I need to
Click to expand...
update the signedoff checkbox to yes.
What do you mean when you say 'comes up again in the future'?

--
KARL DEWEY
Build a little - Test a little


jeremiah said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top