S
SC
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
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