Query Format Question

[Bob]

--
I have this In my Field in my query, Which is giving me this format
Name,Address
Address
Address
Is it possible to change it to
Name
Address Address Address
Thanks for any help..................Bob

NameAddress: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName) &
IIf(IsNull(tblOwnerInfo.OwnerAddress),'',tblOwnerInfo.OwnerAddress)

 

[Van T. Dinh]

It sound like you already have the carriage return in you Field value.
Change the IIf for the Address to:

IIf(IsNull(tblOwnerInfo.OwnerAddress), '',
Replace(tblOwnerInfo.OwnerAddress, Chr(13 & Chr(10), " ") )

(type as one line)

 

[Bob]

Van no matter how I do it I am getting an error " Wrong Amount of
Arguments..............Thanks Bob

NameAddress: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName) &
(tblOwnerInfo.OwnerAddress, Chr(13 & Chr(10), " ") )

 

[Van T. Dinh]

You left out "Replace"

Please check my earlier expression.

 

[Douglas J. Steele]

Is that a literal copy-and-paste, or did you retype it in your post?

Your Chr(13 near the end is missing a closing parenthesis.

 

[John Vinson]

Van no matter how I do it I am getting an error " Wrong Amount of
Arguments..............Thanks Bob

(tblOwnerInfo.OwnerAddress, Chr(13 & Chr(10), " ") )

Typo apparently: there's no closing paren after Chr(13


John W. Vinson[MVP]

 

[Bob]

Ok got it going now BUT I am getting OwnerLastName on the 2nd line with the
address
Thanks Bob

 

[Bob]

Got it now, So how do I force the report to show
Name
Address (One Line)
thanks for all your help.................Bob

 

[John Vinson]

Got it now, So how do I force the report to show
Name
Address (One Line)

Please post your current query.

John W. Vinson[MVP]

 

[Bob]

Please post your current query.

John W. Vinson[MVP]

Thanks John. I have added email as well, what I would like is in this format
on report

Name
Address (Which can be 5 lines on this one line)
Email

Mr Bill Gates
12 Mill St Microsoft Towers Hollywood Californa USA
(e-mail address removed)

NameAddress: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName) &
' ' &
IIf(IsNull(tblOwnerInfo.OwnerAddress),'',Replace(tblOwnerInfo.OwnerAddress,Chr(13)
& Chr(10)," ")) & ' ' &
IIf(IsNull(tblOwnerInfo.Email),'',tblOwnerInfo.Email & ' ')

 

[John Vinson]

Thanks John. I have added email as well, what I would like is in this format
on report

Name
Address (Which can be 5 lines on this one line)
Email

Mr Bill Gates
12 Mill St Microsoft Towers Hollywood Californa USA
(e-mail address removed)

NameAddress: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName) &
' ' &
IIf(IsNull(tblOwnerInfo.OwnerAddress),'',Replace(tblOwnerInfo.OwnerAddress,Chr(13)
& Chr(10)," ")) & ' ' &
IIf(IsNull(tblOwnerInfo.Email),'',tblOwnerInfo.Email & ' ')

What's your question, Bob? I'm not clear at all what you are asking.

John W. Vinson[MVP]