I
Ian Elliott
Thanks for any help.
I am trying to concatenate a field from record(s) into a field, while
grouping them. For example, the query (with no concatenation, but with
grouping) is like:
SELECT Table!name, Table!date
FROM Table
GROUP BY Table!name, Table!date
I would like to make a query that along with grouping by name and date,
makes another field, that is a concatenation of all fields called Policy.
I am trying to do this with Duane Hookum's concatenation function, but can't
figure it out, I think because his function doesn't need a grouping to do it.
But I have to use a grouping I think.
Anyway, the table is like:
Name,Date,Policy
ACUL,2007,123
ACUL,2007,345
ACUL,2006,888
BEUL,2006,999
I would like the query to make:
ACUL,2007,123 345
ACUL,2006,888
BEUL,2006,999
Is this possible?
Thanks for any help.
I am trying to concatenate a field from record(s) into a field, while
grouping them. For example, the query (with no concatenation, but with
grouping) is like:
SELECT Table!name, Table!date
FROM Table
GROUP BY Table!name, Table!date
I would like to make a query that along with grouping by name and date,
makes another field, that is a concatenation of all fields called Policy.
I am trying to do this with Duane Hookum's concatenation function, but can't
figure it out, I think because his function doesn't need a grouping to do it.
But I have to use a grouping I think.
Anyway, the table is like:
Name,Date,Policy
ACUL,2007,123
ACUL,2007,345
ACUL,2006,888
BEUL,2006,999
I would like the query to make:
ACUL,2007,123 345
ACUL,2006,888
BEUL,2006,999
Is this possible?
Thanks for any help.