S
seeker
Why doesn't the following query run?
UPDATE (member_time INNER JOIN member_los ON member_time.member_number =
member_los.member_number) INNER JOIN qry_select_los_service ON member_los.los
= qry_select_los_service.los_id SET member_time.service =
qry_select_los_service.service, member_time.pr_staff =
member_los.pr_staff,locnbr=iff([service]="PRAG",1,0)
WHERE (((member_time.pr_staff)=0) AND ((member_time.date)>=[begin_service])
AND ((member_los.closed)=No));
I want the field locnbr to be updated to 1 only if the field service is
prag. Thank you.
UPDATE (member_time INNER JOIN member_los ON member_time.member_number =
member_los.member_number) INNER JOIN qry_select_los_service ON member_los.los
= qry_select_los_service.los_id SET member_time.service =
qry_select_los_service.service, member_time.pr_staff =
member_los.pr_staff,locnbr=iff([service]="PRAG",1,0)
WHERE (((member_time.pr_staff)=0) AND ((member_time.date)>=[begin_service])
AND ((member_los.closed)=No));
I want the field locnbr to be updated to 1 only if the field service is
prag. Thank you.