Remove Blank Spaces from Text and Concatenate 1

[sacsadmin]

I have two fields Description1 and Description2 pulled from a linked table using a query in Access 2000. This query is used to generate a report.

Description1 and Description2 are 25 character long fields in the linked table. I cannot modify the properties of the linked table.

Some of the data input into Description1 does not take up all the character spaces, so Access shows them as blank spaces in the report.

I can get the two fields to concatenate using:

=([Description1] & "" & [Description2])

But the concatenated line ends up looking like this on some descriptions:

CTN THERMOELECTRIC COOLERS

I would like it to look like:

CTN THERMOELECTRIC COOLERS

Thanks for your help!

 

[randysmid]

Ok,
Just a little note about date fields in queries. You may need to add the # sign before and after your date fields. That is because dates being sent to a query usually get converted into strings. HTH,
Randy Smith
California Teachers Association