Good Afternoon,
I have a query that is outputting 2 fields, but I'm wanting to populate the 3rd [Expr1] based on the [PatronNo] and [Main].
If [PatronNo] is empty I was to display [Main] in [Expr1] or if [PatronNo] is equal to [Main] I want to display [Main] in [Expr1], otherwise display [PatronNo] in [Expr1].
Here is how I'm trying to attempt that:
Expr1: IIf(Val([AllPatrons].[PatroNo])=Val([PatronPayrollInfo].[Main]) Or Val([AllPatrons].[PatronNo])="",[PatronPayrollInfo].[Main],[AllPatrons].[PatronNo])
Can someone please help explain, why 103,104,105,etc are not showing in Expr1 and instead I'm receiving an error.
I've tried modifying this statement over and over and ready to pull my hair out! :banghead:
Thank you in advance.
PatronNo Main Expr1 103 #Error 104 #Error 105 #Error 107 #Error 108 #Error 109 #Error 111 #Error 112 #Error 113 113 113 1131 113 1131 114 #Error 115 #Error 120 #Error 1211 121 1211 121 121 121 124 #Error 129 #Error
I have a query that is outputting 2 fields, but I'm wanting to populate the 3rd [Expr1] based on the [PatronNo] and [Main].
If [PatronNo] is empty I was to display [Main] in [Expr1] or if [PatronNo] is equal to [Main] I want to display [Main] in [Expr1], otherwise display [PatronNo] in [Expr1].
Here is how I'm trying to attempt that:
Expr1: IIf(Val([AllPatrons].[PatroNo])=Val([PatronPayrollInfo].[Main]) Or Val([AllPatrons].[PatronNo])="",[PatronPayrollInfo].[Main],[AllPatrons].[PatronNo])
Can someone please help explain, why 103,104,105,etc are not showing in Expr1 and instead I'm receiving an error.
I've tried modifying this statement over and over and ready to pull my hair out! :banghead:
Thank you in advance.
PatronNo Main Expr1 103 #Error 104 #Error 105 #Error 107 #Error 108 #Error 109 #Error 111 #Error 112 #Error 113 113 113 1131 113 1131 114 #Error 115 #Error 120 #Error 1211 121 1211 121 121 121 124 #Error 129 #Error