changing formats

  • Thread starter Thread starter huggybear551
  • Start date Start date
H

huggybear551

I need to change a column from "date" to "text" in an existing table. When I
highlight the column, it does not give me any other options on the
formatting, just different types of dates. How can I do this?
 
Why do you want to do it in the table and not in a query? You should not
need to be in the table at all.
In your query use the Format function which returns a string oe text.
 
Back
Top