I have a table in MS-Access called Alumni that has two columns with comments in them, i.e., Comment1 and Comment2. I would like to append the values from the Comment2 column into Comment1 so that I can then get rid of the Comment2 column.
How can I accomplish something like this? Can you show me both in terms of query design view and SQL? I have attached a screen shot of the query design.