Kayleigh
Member
- Local time
- Today, 06:28
- Joined
- Sep 24, 2020
- Messages
- 706
Trying to write query to put yes/no in field based on whether a record appears in database and meets specific condition. But could not get this together in one query. Tried multiple combinations of IIF function, dlookup and isNull but could not get to work when in one field - it displays as error when query is run.
This should be the first part of calculation (if safeguarding = true, display yes):
This should be the second part of the calculation (if no associated records, display no):
Appreciate your help once again
This should be the first part of calculation (if safeguarding = true, display yes):
Code:
Completed: IIf(DLookUp("fldTrainingCat","lkptblTrainingCat","fldTrainingCatID=" & [fldTSTrainingCat])="Safeguarding","Yes",(IIf([NotCompleted]=True,"No","")))
Code:
NotCompleted: IIf(IsNull([fldSessionID])=True,"No","")
Appreciate your help once again