Using Crosstab Query for Report (1 Viewer)

Gasman

Enthusiastic Amateur
Local time
Today, 22:36
Joined
Sep 21, 2011
Messages
14,048
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

Enthusiastic Amateur
Local time
Today, 22:36
Joined
Sep 21, 2011
Messages
14,048
@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
 

Users who are viewing this thread

Top Bottom