Query Format Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

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)
 
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)
 
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), " ") )
 
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.
 
Van no matter how I do it I am getting an error " Wrong Amount of
Arguments..............Thanks Bob
Click to expand...

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

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


John W. Vinson[MVP]
 
Ok got it going now BUT I am getting OwnerLastName on the 2nd line with the
address
Thanks 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 said:
Please post your current query.

John W. Vinson[MVP]
Click to expand...

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 & ' ')
 
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 & ' ')
Click to expand...


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

John W. Vinson[MVP]
 
Back
Top