Creating A Date Field

A

atlas

Anyone's help would be much appreciated. I have a large database of over
380,000 records. I have three separate columns representing the day, month,
and year. Does anyone know how I can create a new single column from the
information in those three columns that represents a single date (e.g.,
05/22/2005)? Thank You!
 
D

DL

This is an access db?
If you intend to keep the individual fields creating anything other than
calculated field ie a virtual field for use in other calculation/reports etc
would be a fundimental bad db design - you would be replicating data.
 
Top