If statement for Carraige Return??

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 & Regards,
Ken Chan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement for "Carriage Return" in Query?? 0
Record with multiple lines 1
Replace Carriage Return ASCII Character in Memo Field 3
Carriage return in a text box in a textbox in report. 4
Address box with IIf Statement 7
Carriage Return Symbol Text Field Word Form VBA Problem inside Tab 2
how to insert CRLF (carrage return/line feed) in report 8
How to remove carriage return symbol before importing into excel 2

Top