Help Moving data frm Access to Excel

[Gustav Johansen]

I've got an Access 2003 db I've been using for our school that has three
linked
tables: Clients, Students, Programs.

Many Clients(parents) have multiple students and (thus)programs.

In exporting to excel then importing to outlook Im trying to create
records
that will list multiple students in one field(of one record) seperated by
commas, then
their program ID's in another field seperated by commas so that each
client
has only one record when it gets to outlook.

Access looks like this:

Client1 student1 program1
client1 student2 program2

I would like a query (or the spreadsheet)to look like this:

client1 student1, student2 program1, program2

What would be the best approach? Thanks

 

[Guest]

Try a variation of my post to "concatenate records" this date.

 

[Arvin Meyer [MVP]]

Do you have any data that looks like this?

Client1 student1 program1
Client1 student1 program2
Client1 student2 program2
Client2 student1 program2

If not, you might try gathering the records so that they all show in a query
as in your first example, then running a crosstab query on them. You can
then export the results of that query into Excel. If it does look somewhat
like my example above, you will probably need to run several queries, first
grouping by Client to get results that you use to build a crosstab query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access