insert line feed in access query

  • Thread starter Thread starter Guest
  • Start date Start date
.... and you should insert details of your set-up, what you want to do in
details and the SQL of yuor current Query in the blank space provided on the
post FIRST before anyone can make a reasonable suggestion.
 
Now that is a cryptic request.

A short example of what you are looking for would help.

Do you want a line feed to be inserted in a calculated field in a query?
Between two fields?

In a query, you need to use Chr(13) & Chr(10)
Assuming two fields named street1 and Street2

Field: TwoStreet: [Street1] & Chr(13) & Chr(10) & [Street2]

That will return in one field
Alahambra
Mason
assuming that Street1 = "Alahambra" and Street2 = "Mason"
 
You must log in or register to reply here.

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

adding a Carriage Return or Line Feed character to an update query 2
how do I embed a line feed in a memo field via Query 2
Writing Queries with Line Breaks 2
Access 2010 append query to SQL is very slow 0
Verifying line feed endings 3
Use Insert Into to insert multiple records 9
HP 5L fails to feed 1
Problems using "Like" in query feeding Mail Merge Document 3

Back
Top