Merging 2 fields together

[hopkinsc]

Hi, i am trying to merge 2 fields together. and call it [Stock Movement Reason]

the fields are:

ModifiedNarrative
[Stock Adj Reason].

An example of the data within each field is

ModifiedNarrative
STK Ordering
STK Goods Received
STK Adjustment

Stock Adj Reason
P/O Manual
P/O Picco
Waste Manual
Waste Picco

I want to combine them to make one list
STK Ordering
STK Goods Received
STK Adjustment
P/O Manual
P/O Picco
Waste Manual
Waste Picco

Can anyone help me to do this please?
Thanks very much

[hopkinsc]

Can anyone help with this please??

[hopkinsc]

Anyone on today that can help please?

[#4]

Hi hopkinsc,

I am not able to run the code using ur QVW file since there is no datasource but still u can run the code and check .It will create one more table with similar StoreReasonCode with one additinoal column.

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;

[#5]

Hi hopkinsc,

I am not able to run the code using ur QVW file since there is no datasource but still u can run the code and check .It will create one more table with similar StoreReasonCode with one additinoal column.

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;

[#6]

Hi hopkinsc,

I am not able to run the code using ur QVW file since there is no datasource but still u can run the code and check .It will create one more table with similar StoreReasonCode with one additinoal column.

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;