I have an access file that includes names and addresses.
THe addresses are in separate columns ie 111 North Orange Street
I need to combine them into one column.
Also how to I add a column in Access. (I am very ignorant in Access).
Finally if a date is in a "wrong format' how can it be converted to this format YYYYMMDD.
P.S. WHere in Access 2003 are the templates stored, and what is the extension?