I have revenue data that comes in as text. Sometimes the field contains a 0 sometimes it is null when it is not an actual revenue amount.
I create a table using a query where I am trying to change the text to number so I can add the values together in another query.
Code:
Install_Credit: IIf(IsNull([Rental Credit Install Revenue]),0,[Rental Credit Install Revenue])
Install_TCV: IIf(IsNull([Rental Install TCV]),0,[Rental Install TCV])
The make table creates these fields as Number Double - which is great
When I try and add them together I get a datatype mismatch.
Code:
Total Install Rental Revenue: Sum([Install_TCV])+Sum([Install_Credit])
I am assuming it is the 0 that comes in as text but I can't figure out how to handle it
Thanks in advance