"Paste" 2 fields in a report

  • Thread starter Thread starter denis
  • Start date Start date
D

denis

Hi,
It's me again !
I have the following question : I would like to put in a report 2 fields
aside (ex : zip code + city) but when zip code is empty, have city at the
place of zip code.

Ex :
75012 PARIS
93100 MONTREUIL
COLOMBES
and not
75012 PARIS
93100 MONTREUIL
COLOMBES
Is it possible with Access ?
PS : I use Access 2000.
Thanks a lot for your help
Denis
 
Hi Denis.
The simplest is to combine the two entries in one text
box.if one is null the only the second show.
=([Zip Code]+" ")&[City]
The + in the parenthesis adds a space when the Zip Code is
not null and eliminates the added space when the Zip Code
is null.
Hope this helps
FOns
 
Back
Top