I have a problem with my access database, I have a table that has the column names (see below), and what I want to do is to change the columns into rows in chronological order with the first 7 columns staying the same, this would create a really large document. What is the best way in Access VB to do this.
unittra meas direction partner rep airport 2006a00 2005a00 2004a00 2003a00 2002a00 2001a00 2000a00 1999a00 1998a00 1997a00 1996a00 1995a00...