Combining 2 fields into 1 without Spaces

[paulS30berks]

I have 2 seperate fields within a select query (In this example Field 1 - Country and Field 2 Number).

I have combined the 2 together into one field.

However a space appears within my results i.e


Field 1 Country Field 2 - Number
----------------- -------------------
England 4
USA 10

Combined fields:

Field 3 - Combined Country + Number
--------------------------------------------

England 4
USA 10

How can I remove this space within Field 3


Thanks

 

[Bat17]

can you post the SQL that you are using to combine them please.

Peter

 

[paulS30berks]

Doc: [doccode] & "" & [docnum]

doccode and docnum being the 2 seperate fields

 

[Bat17]

Doc: [doccode] & [docnum] should work unless there is a space in the data, to make sure use
Doc: trim([doccode]) & trim([docnum])
HTH

Peter

 

[paulS30berks]

Thats great thanks