line gaps

[Guest]

THERE ARE GAPS AFTER EACH SENTENCE, HOW DO I GET RID OF THEM

 

[Danny J. Lesandrini]

Your request is vague, but you need to do something like this ...

SELECT Replace([YourColumn],vbCrLf, " ") As NewYourColumn
FROM YourTable

This may not work in a query, with the vbCrLf constant, but if not,
you can try this ...

SELECT Replace([YourColumn], Chr(13) & Chr(10), " ") As NewYourColumn
FROM YourTable

 

[Joseph Meehan]

THERE ARE GAPS AFTER EACH SENTENCE, HOW DO I GET RID OF THEM

You don't need to shout.

Just checking. Are you using the Microsoft database called Access?

 

[simon white]

Your request is vague, but you need to do something like this ...

SELECT Replace([YourColumn],vbCrLf, " ") As NewYourColumn
FROM YourTable

This may not work in a query, with the vbCrLf constant, but if not,
you can try this ...

SELECT Replace([YourColumn], Chr(13) & Chr(10), " ") As NewYourColumn
FROM YourTable
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast

THERE ARE GAPS AFTER EACH SENTENCE, HOW DO I GET RID OF THEM