all notes shown in one column

[Ali29J]

Hi All

I have a query which contains notes from each stage of a quote, i would like to combine all the notes in one column is this possible?

in simple terms at the moment the SQL i have is

SELECT RFQTracker.RFQID, RFQTracker.RFQDetailInputNotes, RFQTracker.QuoteSummaryInputNotes, RFQTracker.QuoteDetailInputNotes, RFQTracker.FreightCalcsNotes
FROM RFQTracker;

I would like amother column to take RFQDetailInputNotes, QuoteSummaryInputNotes, etc, and list them in a single column, a calculated column if you like...

Can anyone help??

Ali

 

[PHV]

Something like this ?
SELECT RFQID, RFQDetailInputNotes, QuoteSummaryInputNotes, QuoteDetailInputNotes, FreightCalcsNotes
, RFQDetailInputNotes & ' ' & QuoteSummaryInputNotes & ' ' & QuoteDetailInputNotes & ' ' & FreightCalcsNotes AS CombinedNotes
FROM RFQTracker

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ali29J]

perfect thankyou