Recent content by Chas

Works perfectly. Thank you Chris!

Hi Chris: I have adapted your cross tab query to my situation, but I am getting inconsistent results. Please see the attached mdb. If you run the query, you get blank spaces where there should be a name. I suspect the problem is in the Pivot part of the query. I have not been able to...

Thank you Galaxiom and Nigel for the reply. I will continue with the thread that Galaxiom suggests. Charlie

I have a table of tenants with data as follows: Suite............Ten1Last .............Ten1First 101..............Smith...................Joe 101..............Smith...................Mary I want to do this to the data with a query...