Update query

I have a database that someone else created and that I can't change table
properties in due to it's permissions. There is a Date of Birth (DOB) field
in it that is in text format but entries look like they are in the short
date format dd/mm/yyyy. I can't run parameter queries like between[start
date]and[end date] against it because the DOB field is in text format. I've
created a make table query that selects the data that I need with the DOB
field and save it to another table that I can change properties in.

Does anyone know how to write an update query that I could put in a macro
and that would change the text format of the DOB field in the make table to
a short date format?

Thanks,

Stuart

First backup the table.

If the dates are valid you can just change the datatype in table design view
and save.

If some records are not changed you might be able to review the data in the
backup table to figure out what the date is.

"SC" wrote:

I have a database that someone else created and that I can't change table
properties in due to it's permissions. There is a Date of Birth (DOB) field
in it that is in text format but entries look like they are in the short
date format dd/mm/yyyy. I can't run parameter queries like between[start
date]and[end date] against it because the DOB field is in text format. I've
created a make table query that selects the data that I need with the DOB
field and save it to another table that I can change properties in.

Does anyone know how to write an update query that I could put in a macro
and that would change the text format of the DOB field in the make table to
a short date format?

Thanks,

Stuart