insert line feed in access query

V

Van T. Dinh

.... 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.
 
J

John Spencer

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"
 
Top