Search results

The content field has more than 15000 characters and It is making my other queries running 10 times faster if I only keep 1500 or 1000. How you will do it with Update Statement ?

I am using Link Table between Ms Access and Outlook I wanted to create a query keeping only 3 fields (Subject, Contents and Received) This query is creating a new Table called New _Table SELECT my_table.Subject, LEFT(my_table.Contents, 1000), my_table.Received INTO New_Table FROM my_table...