Creating one field to summarize several fields

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

Guest

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
 
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
 
You might want to post your SQL view that contains the Concatenate(....)
expression.
 
Back
Top