Integrating columns in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top