Queries in ms-access:formatting a field in the middle of an sql UPDATE code.

Question

Hello again, I am having yet another problem with my data in ms-access.

Basically, what i'm doing is using multiple sql statements to pull, sort, and staight up change/manipulate data. The problem that im having currently is that i am trying to use a sql code like this:

UPDATE analyzedCopy2 SET analyzedCopy2.DateRange = #4/21/2009# to #4/29/2009#

but i can't figure out how to reformat DateRange (which is currently a date) to Text in the sql statement. I can't simply set the format manually because the sql code before this one is pulling in all of the data from another table and when that happens it changes the format of DateRange to date automattically since that is the type it is where it is coming from.

If anyone knows how to format a column with vba code then that would be fine too since i'm creating a vba code to run the queries in the order i want.

If anyone needs a better explanation of anything just let me know.

Answer 1

You can use SQL (DDL) to change some aspects of a table:

 ALTER TABLE TableName ALTER COLUMN  ColumnName Text(50)