Problem with a query design

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

Guest

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
 
Back
Top