Using Crosstab Query for Report

[Gasman]

tmyers, Excellent.

Gasman, Since Access no longer supports A97 I can't even look at the example. I don't know if Roger is maintaining his library or if someone else has taken it over. Do you know?

Pat,
I would not know that. I just did a quick Google for a way.
I converted that DB to 2007 for the O/P. Probably one of the few benefits left to using 2007.
This DB was by someone called Duane Hookom

FWIW if anyone ever needs a MDB converting and are unable due to having a version of Access that objects to converting it, they only need to upload and ask, or PM me.

 

[Gasman]

@abdullahkhan Re your PM about the code in post #3

gCallSystem is a global variable (hence the g) and appears to be a string value as I surrounded it in quotes.?

It would hold the name of the call recording system I wanted to report on, or be blank if I wanted to report on all.?

It would be set just before calling this code?, probably from a combo.?

That DB is not on this computer, so I would need to go to the works computer if this is still not clear.?

HTH