
June 9th, 2006, 09:45 AM
|
|
Contributing User
|
|
Join Date: Feb 2005
Posts: 273

Time spent in forums: 2 Days 7 h 19 m 28 sec
Reputation Power: 9
|
|
Doh, well, in Report Builder the only way I can seem to make it work is by using
Code:
query.FullName & Chr(10) &
IIf(replace(query.Address1, '#', '') is '', DE(''), DE(query.Address1 & Chr(10))) &
IIf(replace(query.Address2, '#', '') is '', DE(''), DE(query.Address2 & Chr(10))) &
query.CSZ
as an example, with the IIF's...but I can't get it to go right.
|