Access 2003 Report - Removal of Carriage Return and Line Feed

O

Optomyst

I need to generate a report when inputting a Sales Order, it searches the
table and returns all the work orders asscociated with that sales order. The
report must list the work orders reading left to right, with a comma between
each work order.
i.e.
Work orders assigned to Sales Order: 1234

1222, 1223, 1245, 1253

Something as simple as that
 
O

Optomyst

Hi Duane,

I tried this with 2003 and it does not work. In fact, the word
"Concantenate" disappears in the query and I get an error message " Only 1
record can be returned from this query"

Thoughts?

here is my table structure:

id numerical Long Integer (Primary Key) This is the workorder number
sales_order numerical Long Integer (Key with duplicates) This is what I
will be searching for

One sales order can have mutliple work orders (ID)


Hopefully this helps
 
D

Duane Hookom

"Concantenate" is not the correct spelling. Do you mind sharing the SQL view
of your best attempt at getting this to work?
 
Top