Sounds like you should use an Aggregate Query and base the report’s Record Source off of that.

Here’s the video that’s covered in:
Aggregate Query: https://599cd.com/blog/display-article.asp?ID=1564

Access Expert 11 also starts going over Aggregate Queries:
Expert Level 11: https://599cd.com/blog/display-article.asp?ID=3027

AH Thank you will have a look at that.  I thought Access would have something.  Will check in when done.  Thanks again.

Hi folks.  Well the aggregate query did do the trick thank you.  But.  In the table I am doing the report on I use the category I’d number to save space in the table as you would expect in relational db.
When I do the query the grouped part is the id, how do I now relate the id to the actual category name to group them.  I could insert the names but would defeate the purpose.  Hope it’s quite clear what I mean.  Thanks again for your support.

Join the table with the name

How would I go about that?

I think I have found how to.  Drag from one table to another I’m guessing?

In a Query

Hi again  have managed to create a query for all incoming and a query for all outgoings.  Now trying to put both as 2 columns on a report but it wont allow that is this at all possible.  Thank you.

Union Query
Or
Subforms