Question on exporting table data.

[Brandon]

Hello everyone,

What I have is a normal table of values with the following column headers:

Item Question References Status Action

Is there any way to output these to a report in a similar, but neater,
manner than the delimited export to text document option? I would like for
them to be seperated by commas and be on the same line so when it is finished
I will have a list of each row as follows:

1, Are the frequencies within operating parameters, REFERENCE, Satisfactory,
Performed test on 1 Jan 2010.

2, Are the pulse widths within operating parameters, REFERENCE,
Satisfactory, All data has been proven to work within operating parameters.

The delimited text export works in the format I want, but I was wondering if
there was a neater way to do the same thing with maybe a report or a word
document as opposed to just a regular text document.

 

[Arvin Meyer [MVP]]

A query column can concatenate fields with any additional character or
space. So, for instance you could:

Output: [Item] & "," & [Question] & "," & [References] & "," & [Status] &
"," & [Action]

 

[Brandon]

You are awesome. Thank you for the help! Worked great.

- Brandon

A query column can concatenate fields with any additional character or
space. So, for instance you could:

Output: [Item] & "," & [Question] & "," & [References] & "," & [Status] &
"," & [Action]

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hello everyone,

What I have is a normal table of values with the following column headers:

Item Question References Status Action

Is there any way to output these to a report in a similar, but neater,
manner than the delimited export to text document option? I would like
for
them to be seperated by commas and be on the same line so when it is
finished
I will have a list of each row as follows:

1, Are the frequencies within operating parameters, REFERENCE,
Satisfactory,
Performed test on 1 Jan 2010.

2, Are the pulse widths within operating parameters, REFERENCE,
Satisfactory, All data has been proven to work within operating
parameters.

The delimited text export works in the format I want, but I was wondering
if
there was a neater way to do the same thing with maybe a report or a word
document as opposed to just a regular text document.

.