IF statement for "Carriage Return" in Query??

K

Ken Chan

MYOB accounting system requires items in same Invoices
with no line spacing, new invoices with one line spacing.
Is there a way to add in IF statement so that it will put
in "Carriage Return" for next new invoices no??

My statements,
SELECT INVOICE.CUSTOMER_ID, INVOICE.INVOICE_NO, Chr(13) &
Chr(10) AS NL
FROM INVOICE INNER JOIN [INVOICE-DETAIL] ON
INVOICE.INVOICE_NO = [INVOICE-DETAIL].INVOICE_NO;

Or I have to use VB+ADO to compile all data in Word doc
and export as txt?? Any sample script?

Thanks Again,
Ken Chan
 
Top