You are probably going to need Access to do this and do it in multiple steps. You would first need to build a table with the invoice data and check number.  Now for the GL an Invoice hits many tables, AR, COGS, Sales, Inventory, Freight. Did you  need it for every account it hits?

You are probably going to need Access to do this and do it in multiple steps. You would first need to build a table with the invoice data and check number.  Now for the GL an Invoice hits many tables, AR, COGS, Sales, Inventory, Freight. Did you  need it for every account it hits?

No i just need the ones that hit the 1400 up to 1413 the assets accounts.

Just curious if you got a solution to this?  I have been tasked to create a report like this.  The comments that are generated combine several field and I would like to break them apart.  Thanks!