CONCATENATE

[BB]

I have concatenated several text fields in a query to update a table. When I
run the query the text fields that contains blanks at the end is suppressed.
Is there a funtion that will allow the query to retain the blanks?

 

[KARL DEWEY]

In query crieria include Or Null and it should work.

If not then post the SQL of your query -- Open in design view, click on VIEW
- SQL View, highlight all, copy, and paste in a post.

 

[John W. Vinson]

I have concatenated several text fields in a query to update a table. When I
run the query the text fields that contains blanks at the end is suppressed.
Is there a funtion that will allow the query to retain the blanks?

Are you trying to store multiple different field values redundantly in a
(non-atomic, composite) field? If so... WHY!? That's a *really bad idea*.

The blanks are being suppressed because Access Text fields are what a SQL
developer would call "nvchar" - trailing blanks all get trimmed off before the
field is stored. If you store "ABC "
into a text field, its size will be 3 bytes and it will contain "ABC".