Generate address in report using IIf IsNull

[KenHigg]

so instead of
=[par_id] & ", " & [par_name] & ", " & IIf(IsNull([par_name]), "", [par_name])

you have to write

=[par_id] & ", " & [par_name] & ", " & IIf([par_street] Is Null;"";[par_street])

Not in my version of Access...

???
ken

 

[Brianwarnock]

Now I'm really puzzled

=IIf(IsNull([pers Title]),"",[pers Title] & Chr(32)) & IIf(IsNull([pers Surname]),"",[pers Surname] & Chr(44) & Chr(32)) & IIf(IsNull([pers ad1]),"",[pers ad1] & Chr(44) & Chr(32)) & IIf(IsNull([pers ad2]),"",[pers ad2] & Chr(44) & Chr(32)) & IIf(IsNull([pers ad3]),"",[pers ad3] & Chr(44) & Chr(32)) & IIf(IsNull([pers ad4]),"",[pers ad4] & Chr(44) & Chr(32)) & IIf(IsNull([pers ad5]),"",[pers ad5] & Chr(44) & Chr(32)) & '.' & IIf(IsNull([pers postcode]),"no pc",[pers postcode])

works fine for me on a test I just did.

Brian

 

[Ramzess II]

well yeah, I am sorry - I forgot to mention that I use access xp instead of 97. Now I will notify 'bout this as a first thing.

 

[KenHigg]

Must be a regional/settings issue?

???
ken

 

[Brianwarnock]

Access 2002 with 2000 file format accepts either code.
Brian