I have been working on this query the whole day and if my head was not shaved, I could be bold from pulling it by now. If
anyone can kindly help me please find my query below;
I am using MS Access 2007, we recently changed our Dbase structure. both fields dbo_Agreement.OldMSISDN and
dbo_AgreementDetail.MSISDN are Text fields, so I'm trying to convert the results into long int.
Some of the values for the numbers are blank. that is why I want to replace them with the value (1) so that I could use it in
subsequent queries. like put a criteria: Where CellNumber >1
at the moment, (with the above query) I can only get the values from the dbo_Agreement.OldMSISDN but the second part of the
IIF returns (#Error) even where the values in dbo_AgreementDetail.MSISDN are blank or cellnumber exist.
Any help offered will be greatly appreciated.
Phil, Cape Town.