Adding Text To A Report

[Scott2112]

Hello all,

I am trying to add text to a report, and am having some difficulties. I am using Access 2007.

My report is tied to a query. The query contains 2 fields-
Hostname and MAC Address

I want run a report against the query, but need to add several commas. So the output of the report would look like this:
hostname,MAC Address,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

I then want to export the report to a plain CSV file.

I thought I could just add a textbox with a comma in the report, but that didn't work well. When I added the text box, Access also created a column header that I did not need.

I've also noticed that when exporting a report to CSV format, there are several characters (pipes and such), that help with the formatting of the report. Is there any way to remove this formatting?


Any help is greatly appreciated!

thanks so much!

 

[perlfan]

Add a textfield and delete the caption. The content of the textfield should be: =[hostname] & ", " & [MAC Address] & ", " & ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,"

 

[Mihail]

Add a LABEL with commas.

 

[Scott2112]

Perlman and Mihail,

Thank you for the suggestions, I will give those a try and report back.

Much appreciated!

Scott

 

[Scott2112]

Perlman and Mihail,

Thank you both again for your suggestions. My report now works correctly!

Regards,

Scott

 

[Mihail]

Glad to help you, but we need too to learn something from this forum.
So... what was the solution that you adopted ?

 

[Scott2112]

Mihail-

I used the answer provided by Perlfan.

Thank you again,

Scott