Is there a way in a query or after doing a make table query to change the
date formating? I need to change all the dates of a data set, without
changing the table, so in a query or a new table, that is a make table query.
I need to change them from the format of 7/18/2005 to 07182005. Does
anyone have any suggestions???
Thanks,
Chris

Hi Chris,

Have you tried a format like this: ddmmyyyy


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Chris" wrote:

> Is there a way in a query or after doing a make table query to change the
> date formating? I need to change all the dates of a data set, without
> changing the table, so in a query or a new table, that is a make table query.
> I need to change them from the format of 7/18/2005 to 07182005. Does
> anyone have any suggestions???
> Thanks,
> Chris

No problem - you do not format dates in a table - only in the display such as
query, form, or report.
Format([YourDateField],"mmddyyyy")

"Chris" wrote:

> Is there a way in a query or after doing a make table query to change the
> date formating? I need to change all the dates of a data set, without
> changing the table, so in a query or a new table, that is a make table query.
> I need to change them from the format of 7/18/2005 to 07182005. Does
> anyone have any suggestions???
> Thanks,
> Chris