Search results

Okay then want I want to do is qualify by saying.. AND [SAON_TEXT]= I need it to bring back anything which has a value in [SAON_TEXT] AND [SAON_START_NUM]= I need it to bring back anything which has a value in [SAON_START_NUM]

Thank you for your help CJ... Clearly you know your stuff, unlike myself whois still getting to grips with this Can you clear thinsg up fo rme further please Why does this not work? UPDATE GS_LLPG_With_Addresses SET GS_LLPG_With_Addresses.Sub_Addr = (IIF((([PAON_TEXT]= "Abbey Parade" AND...

Hi all, I hope you are all well. Could someone please kindly help me with the following.... I am trying to get an IIf statement to work, but I am not quite sure how I can lay it out properly so that it works So this is what I need (IIF(([PAON_TEXT]= "Abbey Parade" AND [SAON_TEXT] AND...

Paul you are a star. Tried the NZ then got rid of the IIF's shortened my statement considerably Thank you so so much

Paul, Once again thanks So what I need to say now is this... If there is an empty value/null value in the [PAON_START_NUM] then use the value that is in [PAON_TEXT]) I amatuerishly thought it would be this.... (IIf(IsNull([PAON_START_NUM]),([PAON_START_NUM]), & "-" "") & (IIf(Not...

Thank you so much for the reply. The issue I have is that I am trying to fix somebody elses db which they created who has now left They use the IIF statement for example & IIf(Not IsNull([PAON_START_NUM]),[PAON_START_NUM],"") & IIf(Not IsNull([PAON_START_SUFFIX]),[PAON_START_SUFFIX] & "...

I have an issue which I need help with I am trying to get access to do the following If [column 1] is blank then use the data out of [column 3] and shoved it into [Column 4] can anyone help? many thanks

A big hello to all of you. I would like to introduce myself, my name is Jose and I live in the U.K (Though I am originally from Spain). I have lived in the U.K for most of my life My background is in IT Infrastructure, and managing IT Infrastructure. I am new to the whole db and development...