Definere længde af tekstfelt i forespørgsel

SELECT Left(50, SomeField) As AField FROM TheTable ....

Wiseguy> I dont think this solution is going to help so much though, it only ensures that only 50 characters are selected from tekst. But if you are creating a NEW table from the output of the query then the length of the field will VERY LIKELY default to 255. I would suggest that you make a copy of the originla table and then just use a append query to INSERT the records. This way the fields will be exactly the same.

If necessary you can run some code which empties the table first.

Ellers kan man med fordel definere tabellen på forhånd og derefter bruge en tilfeøjelses-forespørgsel i stedet.
Dog skal man lige huske at køre en slette-forespørgsel inden.

docmd.RunSQL "Delete From DinTabel"
docmd.RunSQL "Insert Into DinTabel ( field1, ...."

Derved kan man også definere indekser og valideringsregler m.m., hvilket ikke er muligt med en tabeloprettelsesforespørgsel alene.

/Thomas

wiseguy, how about responding, cant help otherwise!

Terry, relax - it has only been 6 hours from your reply until your impatient message.

I har begge svaret nogenlunde det samme, så jeg har valgt at dele pointene mellem jer. Tak for svaret.

wiseguy>We are not here on YOUR DEMAND we are here try try and help those who need it which in this case includes you. BUT we can NOT help if you arent prepared to comment the answers give. Another time I might just let you wait six hours before you get an answer :o)