Skip to Content
0
Former Member
Feb 25, 2009 at 04:42 AM

Report Design

26 Views

I have a table that contains the following information.

Acct#   Document

123       Doc1

123      Doc2

456       Doc1

456       Doc2

789      Doc1

789       Doc2

789       Doc3

I am wanting a report that would give me all accounts that do not have a Doc3. For the accounts that do not have a Doc3 I would like a list of the docs that the account does have.

For example the results I am looking would be something like this

123 &nbsp; Doc1 <BR>

&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Doc2

456 &nbsp;Doc1 <BR>

&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; Doc2

Any suggestions are appreciated.