im retarded
sorry for the waste of anyones time
i just say the = is in the wrong place
Norgi
Last Activity: Apr 22 '14, 03:10 PM
Joined: Apr 22 '14
Location:
-
The Expression you enters contains invalid syntax (if statement)
kk so ive been looking at it (and im pretty new to access)
but i dont know what is wrong with my statement
plz help
...Code:= SiteIncome IIf([LocationsT].[SiteID]=1, [Totalincome].[castleblackincome], IIf([LocationsT].[SiteID]=2, [Totalincome].[Torontoincome], IIf([LocationsT].[SiteID]=3, [Totalincome].[Edmontonincome],Last edited by zmbd; Apr 22 '14, 12:18 AM. Reason: [z{added required code tags}{stepped the code for easier reading}]
No activity results to display
Leave a comment: