Problems with trimming combined field when using Make Table

[KarlBrix]

I need to trim a field when creating a new table with make-table, but I have encountered problems, whatever I have done.
What I did in Queries in Access 2000:
1. ((tblFund.Nr)&(tblFund.Date) AS JournNr), among similar stuff, then...
2. Trim(tblNew.JournNr) AS Something, as a Make Table query creating table Test2.
I have tried Left(tbl.field,12) and LTrim()
3. Result in new created table Test2: Field length char 255.

Are there any other possibilities I haven't tried in query or VB, whatsoever?
Best regards
Carlito

 

[nickjar2]

try putting this in your make table

expr1:Left([fieldname],12)

Nick

 

[KarlBrix]

The discussion has moved on to Microsoft: Access - General Discussion - forum. Thanks anyway, please join
karlbrix