Hello! I'm in the process of creating a report in Microsoft Access, but am running into a problem. I have a number of clients that include fields such as ID, last name, first name, address, etc. and then their account numbers. Each client has a number of different accounts. The problem is that each client's last name, etc is listed again for each different account they have, so the query results looks like this:
ID Last Name Account #
1 Smith 123-56
1 Smith 4458-66
2 Jones 523-63
2 Jones 4525
2 Jones 5236
3 Roberts 5225-56
4 Johnson 523-55
I want the names and client contact info to appear only once in the report and all of the account #s to show also. Any suggestions would be GREATLY appreciated!