sashapixie
Board Regular
- Joined
- Aug 29, 2013
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Hi There
I have the following formula entered into the expression builder of a field in a access report.
=IIf([AccessTotalsTraining Course]=[Group Attendees' Required],[Cost Group Booking],"")
Unfortunately I am returning an error and have no idea what the issue is. The false part is working as I have records returning blanks but when the statement is true it will not return the value in the cost group booking for the course appearing in the training course header.
I have a feeling this is because I am not telling access which course to look up to return the cost group booking for that course but I do not know how to do that
Any help would be appreciated.
I have the following formula entered into the expression builder of a field in a access report.
=IIf([AccessTotalsTraining Course]=[Group Attendees' Required],[Cost Group Booking],"")
Unfortunately I am returning an error and have no idea what the issue is. The false part is working as I have records returning blanks but when the statement is true it will not return the value in the cost group booking for the course appearing in the training course header.
I have a feeling this is because I am not telling access which course to look up to return the cost group booking for that course but I do not know how to do that
Any help would be appreciated.
