I have to import data from a RS6000 application into Access 2000 to run a report.
With this data there is a comment field in the RS6000 application one work order will show all the comments for that work order, but in Access each line of the comment is a separate record. I need to write a procedure that will string together the comments for each Work order into one field (a memo field) I am not sure how to start? Below is a list of the fileds and thier types
ID (auto Number)
WorkOrder (Text)
Customer (text)
Make (text)
Model(text)
Serial(text)
DateCompleted(Date/Time)
DateOpened(Date/Time)
KohlerId(text)
KohlerAsset(text)
DeptNumber(text)
Comment(text)
Can I run something based on the work order?
