concatenation of multiple rows into a single row

[ssheth]

I am using Access 2007. My data consists of rows with identical information
except for date values. I want to concatenate the rows into a single row so
that I can see, along with the other information, the date values in the
single row. Here is an example:

MemberID DataDate
16 6/18/2009
16 3/26/2009


Here is the desired format:

Member ID DataDate1 DataDate2
16 3/26/2009 6/18/2009

Is this possible with Access '07?

 

[Banana]

What you want is called "Crosstab query". Google for that keyword, and
you should be able to find several example how to build a crosstab query
in Access.

 

[Gina Whipp]

ssheth,

Have a look at... http://allenbrowne.com/func-concat.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm