Silly report question

  • Thread starter Thread starter dgrdinh
  • Start date Start date
D

dgrdinh

Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?

thanks
 
Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?

thanks
Click to expand...

=[address] & ", " & [city] & ", " & [state] & " " & [zip]
 
Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?
Click to expand...


The concatenation operators & and + can be used to do that.
The difference between them is that & supresses Null values
while + propogates Null values. In your case, I think you
may want to use a mix of the two. Use a single text box
with an expression like:

=(address + ", ") & (city + ", ") & state & " " & zip

The + will suppress the associated ", " when the
corresponding field has no value (i.e. it's Null).
 
Back
Top