P
Pietro
Hi,
In my query i've a field called 'service request' this field is formatted
as a general number.
In another query,as i need to add number 9 before the service request
number in certain case,the number format is changed,so whe i try to link both
fields from both queries i get a message "type mismatch' as the SR field
format changed from number to text,i try to do the below code in the query to
reatain the original format "genaral number but i cannot,do you have
suggestions?
SR: Format(IIf([queue]='XCD CAR CONTACT',9 & "" & [Service Request],[Service
Request]),"00000000000")
In my query i've a field called 'service request' this field is formatted
as a general number.
In another query,as i need to add number 9 before the service request
number in certain case,the number format is changed,so whe i try to link both
fields from both queries i get a message "type mismatch' as the SR field
format changed from number to text,i try to do the below code in the query to
reatain the original format "genaral number but i cannot,do you have
suggestions?
SR: Format(IIf([queue]='XCD CAR CONTACT',9 & "" & [Service Request],[Service
Request]),"00000000000")