Grouping did not work I tried that for this and I was able to figure it out. I went into the database table linking area and removed some of the links to different tables and created a few new ones and it worked like a charm.
Thanks for the reply.
I need to be able to remove duplicates in a report. I have tried the different features such as Suppress if duplicated.
The report is showing everything to do with the client and I only want to show what is the current service the client is receiving.
Data looks like
CID, CName, CAddress...
I have just started working with access. After doing some research it is great match for what I do with excel to help maintain data and provide data on the fly for updating.
Mike