Access 2003 Report - Removal of Carriage Return and Line Feed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
"Concantenate" is not the correct spelling. Do you mind sharing the SQL view
of your best attempt at getting this to work?
 
Back
Top