Adding a table value into a sentence on a form

[John C]

I am trying to add a table value inside of a sentence in access 2010. In excel it would look like this



="I have "&B138&" days to complete this"

how do I do the same in access?

[ranman256]

in what , a query , a report, a form?

in a query
"I have " & [field] & " days to complete this" as Sentence

in report/form the text box
="I have " & [field] & " days to complete this" as Sentence

[John C]

Thanks ranman256, it was simple and a silly question "concatenate text" solved this. Do you know of any way to increase the text field over 256 characters? a memo doesn't seem to allow me to enter any calculated fields.