Combine Text Fields in Report

[Mary]

Hello,
I am trying to combine text fields on a report and get an
error message. The fields are [Duration] and
[Misc_Info]. I want them to print on a report with
Duration first, then Misc_Info. Access 97 help shows =
[Duration] & " " & [Misc_Info]. This isn't working. I've
tried substituting the & with And, this didn't work
either. Any suggestions?

 

[Cheryl Fischer]

Mary,

=[Duration] & " " & [Misc_Info] should work fine. Just make sure that
the ControlName for this text box is not the same as a Field in the report's
RecordSource.

 

[Mary]

That was it.
Thanks!
Mary

-----Original Message-----
Mary,

=[Duration] & " " & [Misc_Info] should work fine. Just make sure that
the ControlName for this text box is not the same as a Field in the report's
RecordSource.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hello,
I am trying to combine text fields on a report and get an
error message. The fields are [Duration] and
[Misc_Info]. I want them to print on a report with
Duration first, then Misc_Info. Access 97 help shows =
[Duration] & " " & [Misc_Info]. This isn't working. I've
tried substituting the & with And, this didn't work
either. Any suggestions?

.

 

[Kylie]

Hi there,

I have Access 97 and use this feature on several of my
reports. Ensure that there are spaces everywhere that
i've indicated on your email below with an underscore.

Hope this helps.