Query design

P

Pammy

Is there a way if I run a query on an employees table, when it is brought
back it will list the name only once with lines of infor until another group
is found Example of the query return:
Doe, John 1 1
Doe, John 1 1
Doe, John 1 1
Smith, Jill 1 1
Smith, Jill 1 1
I want it to look like this:
Doe, John 1 1
1 1
1 1
Smith, Jill 1 1
1 1
 
J

John Spencer

You can do that in a report, but it is not really possible in a query.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top