Breaking up Date Fields

[bomantas]

Hey peeps! I'm wondering if there was a way to break up a date field
into three seperate fields for Month, Day, and Year respectively. I
want to know if there is a way to do this without goign back and
manually reentering dates for thousands of records. Help me pleez!

 

[cabong]

*Hey peeps! I'm wondering if there was a way to break up a date
field into three seperate fields for Month, Day, and Year
respectively. I want to know if there is a way to do this without
goign back and manually reentering dates for thousands of records.
Help me pleez!

*

You could use something like Month([Date]) or Year([Date]) and so
forth, and create a make table query.

 

[bomantas]

Could you elaborate a little further. I don't quite understand what you
are trying to say. Right now I have the date in one field, formatted
to be displayed as 12/12/04. I would like to break it up if possible
into three different fields for month, day, then year.

 

[cabong]

*Could you elaborate a little further. I don't quite understand what
you are trying to say. Right now I have the date in one field,
formatted to be displayed as 12/12/04. I would like to break it up
if possible into three different fields for month, day, then year.
*

You could create a query based on that original table (date field) that
would contain 3 additional columns using the formulas I gave you.

Then you could use that query to create a new table including these 3
fields. Once you are satisfied with the result, you could use that
table as a replacement for your original table.

Now if you don't know what an append or make table query is, I suggest
you get a good Access book before attempting anything.