Integrating columns in a table

J

Jenn L.

If I am working in a massive table in Access and notice that my date is split
into 3 different colums, how would I integrate the three values in order to
have the date in a single column?
 
R

Rick Brandt

Jenn said:
If I am working in a massive table in Access and notice that my date
is split into 3 different colums, how would I integrate the three
values in order to have the date in a single column?
Click to expand...

Add a new column that is a DateType and then use an UPDATE query.

UPDATE TableName
SET DateFieldName = DateSerial(YearField, MonthField, DayField)

The above assumes your three current fields are numeric. Once the update
has been run and you are satisifed that the date field is correctly
populated you can then remove the three separate fields.
 
Top