Cross Tab Queries. Sub Colummns Possible?

[Jameo]

Hi all,

I was just wondering if it was possible to create a cross tab query that has sub column headings.

For example, I would like a parent column, with a site name, and under that, have other options i.e

 _________________________________________________________________________________
|               Site Name 1              |              Site Name 2               |
|________________________________________|________________________________________|
|Max Deliverability|Actual Deliverability|Max Deliverability|Actual Deliverability|
|__________________|_____________________|__________________|_____________________|

There woulld be date and time row headings to the left of the above example. I've had a search around online but cant really find anything. Any help would be great.

Thanks in advance

 

[Galaxiom]

Remember Access queries and tables are not spreadsheets. They just store and retreive data in fields so as such the "columns" are not modifiable like they are in Excel.

Users should never see a table or a query because data is presented in forms and reports. These can be designed with that kind of appearance by using subforms or subreports for the two sites.