Creating one field to summarize several fields

A

Alicia

I have a table with the following:

Event Order Date
1 1 1/1/05
1 2 1/1/05
1 3 1/1/05
2 1 1/1/05
3 1 1/10/05
3 2 1/10/05
3 3 1/10/05
3 4 1/10/05

I would like to have a query that updates a new filed in this table (or I
can also create another table to track the "string"), for example "order
string" that updates this field in this table (or new table). According to
the example above, the dynaset would be:
Event OrderString
1 1,2,3
2 1
3 1,2,3,4

I am not a programmer and lack the knowledge to begin to process this need.
Thanks in advance,
Alicia
 
A

Alicia

Thanks for the reply. I founf this reference that you gave someone else on
an earlier post. I downloaded the file and cannot seem to duplicate it with
my field names. I'll keep trying. I wish I new more about programming.
Thanks again, Alicia
 
D

Duane Hookom

You might want to post your SQL view that contains the Concatenate(....)
expression.
 
Top