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 Doc1 <BR>
Doc2
456 Doc1 <BR>
Doc2
Any suggestions are appreciated.