Search results for query: *

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

You are right tempclerk, but when I changed the field size in the new table, the size was fixed still after appending or updating. So it works, but it is probably not a perfect way to do, though is it fairly straightforward. If you have more efficient ideas, please let me know. karlbrix

I think it will help a lot! I will get back tomorrow if it didnt work. Next thing for me is to make it automatical via a macro. I guess I'll be back. Best regards and thanks a lot. Karlbrix

Sounds like a reasonable and easy solution from tlbroadbent. However, if new data is entered into my original table (called tblFundanmeldelse2), how I am to update the new table, without altering the new field setting or overwriting the table. What could I use then instead of Make table? Best...

Thanks Joe I just tried, what you wrote. It does take the characters needed 4, 12 or whatever from left. But, I have probably not correctly explained, that I need the field size of the new field to be minimized according to this. It is still 255 char. Thanks a lot anyway. Karlbrix PS. I do not...

Here is what I did: In: Table tblFundanmeldelse2 tblFundanmeldelse2 = 40 char in Query sqlFundanmeld: SELECT ('OBM'+(tblFundanmeldelse2.Jnr0) AS OBMJournNr, etc... In query sqlBySagsGISDB2: SELECT Left(sqlFundanmeld.OBMJournNr,12) AS JournNr INTO tblTest2 In tblTest2: JournNr = 255 char (I...

Thanks guys, but it is more or less what I have tried myself. My aim is to create a new field by combining 2(Are there any differences between using + or & ?), which is no problem, although I want the new field to be only 12 char long (text). The two fields are 40 and 50 char long (I didnt made...

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...

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...