formatting data

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

Guest

my website captures a "consumer interest list" so a new row is created each time a consumer express interest in another product. This data is then pulled (via SQL) and dumped into an access database table. I would like to be able to send each consumer an email letting them know the status of each item (using mail merge). To do this I need to transpose my data such that each consumer has one row of data with a column for each item of interest. How do I convert the rows of data to columns?
 
| my website captures a "consumer interest list" so a new row is created
each time
| a consumer express interest in another product. This data is then pulled
(via SQL)
| and dumped into an access database table. I would like to be able to
send each
| consumer an email letting them know the status of each item (using mail
merge). To
| do this I need to transpose my data such that each consumer has one row
of data
| with a column for each item of interest. How do I convert the rows of
data to columns?
|
 
Hi Shannon,

Try the first download at:
http://www.eade.com/AccessSIG/downloads.htm
(zipped PDF file 276 kb)

This shows you step-by-step approach to creating a crosstab query in the sample Northwind
database. This database is usually available on your hard drive, or you may need to add
it from your installation disk. Search for Northwind.mdb.

Tom
__________________________________


You can try the crosstab query to transpose your rows into columns.

Hope this helps,

--
Eric Cárdenas
Access support

__________________________________


my website captures a "consumer interest list" so a new row is created each time a
consumer express interest in another product. This data is then pulled (via SQL) and
dumped into an access database table. I would like to be able to send each consumer an
email letting them know the status of each item (using mail merge). To do this I need to
transpose my data such that each consumer has one row of data with a column for each item
of interest. How do I convert the rows of data to columns?
 
Back
Top