Problem with a query design

[Mike]

In my database I have a table with two columns: "DocumentNumber" and
"DocumentDate".
For example:

DocNumber DocDate
123 02/02/07
456 02/02/07
789 02/02/07
987 02/03/07
654 02/03/07
.... ........

I need a query which can return one record with all document numbers
registered on the same date.
For example:

DocNumbers DocDate
123, 456, 789 02/02/07

Please, give a hint.
Thank you in advance!

Mike

 

[John Spencer]

I use Duane Hookom's generic Concatenate() function. The code is at

See:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..