Combine Field from Multiple Records into One

[ano1optimist]

I have a table that contains empno and qtr - it looks similar to:
0001 1
0001 2
0004 3
0004 4
0005 5
and I'm trying to make it look like:
0001 12
0004 34
0005 5

This is a parameterized query that uses values from an open form to
run the queries. I'd prefer completing this task in a query instead
of performing it in the report itself. If it can't be done in query,
then report will suffice.

Your suggestions are appreciated.

[Allen Browne]

Requires some code. For details, see:
http://www.mvps.org/access/modules/mdl0004.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ano1optimist" <an**********@aol.com> wrote in message
news:25**************************@posting.google.c om...

I have a table that contains empno and qtr - it looks similar to:
0001 1
0001 2
0004 3
0004 4
0005 5
and I'm trying to make it look like:
0001 12
0004 34
0005 5

This is a parameterized query that uses values from an open form to
run the queries. I'd prefer completing this task in a query instead
of performing it in the report itself. If it can't be done in query,
then report will suffice.

Your suggestions are appreciated.