I'm self teaching myself Access. Hopefully someone can give me pointers on how to resolve my situation.
I currently downloaded a table that gives me peoples DOB's in text format "01011999."
I run an "update query" to make the date "01/01/1999." But the table still has it as a text field. I know I can change it in the table "design view" data type option. But I'm going to be downloading this table every month. Later I'll make a Marco.
Now that my table has the correct outline, can I create another query or something to convert it over to a date/time field?
My end goal is to download this report and return to me all the children that are about to turn one. Its about 4000 people per month I need to separate children turning one.