Simple Carriage Return!

[riekie]

Hi, I have a table called Customers:

I have a column called Address

With Records like this:

Address
Farm, Long Road, North

I want to use a Carriage Return query to make the record read like this:

Address
Farm
Long Road
North

I know I can use Chr(13) and Chr(10) within the query.
But Dont know how to structure it in SQL or simple Design View

Thanks

 

[jdraw]

Here's a sample from the immediate window

x="city, town, state, zip"
x= replace(x,", ", vbcrlf)
?x
city
town
state
zip

So in your sql you could try

Select Replace("Address",",",vbcrlf) as AddressVertical from Customers;

you could replace vbcrlf with Chr(10)& Chr(13)