Blank Columns in Access Query

[Crasybebe]

Does anyone know if there is a way to program a query to produce a report with a blank column for every other row?

Example
Cross tab Query:

TRANSFORM Val(Nz(Sum([Openings by Country].[OPEN POS]),0)) AS [SumOfOPEN POS]
SELECT [Openings by Country].COUNTRY, [Openings by Country].Region
FROM [Openings by Country]
GROUP BY [Openings by Country].COUNTRY, [Openings by Country].Region
ORDER BY [Openings by Country].Region
PIVOT [Openings by Country].LOB;

I would like the report to display a blank column in between each LOB.

Any ideas are much appreciated.

Thanks!

 

[SydneyGeek]

You can define the headers in the crosstab's properties.

Right-click in the grid, in the Column Headings field (LOB). In the Column Headings property enter the field names -- "A","A_Blank","B","B_Blank"... etc
Where A, B, etc are the LOBs and the others are the desired blank fields.

Disadvantage: If the LOBs change you will need to adjust the headers because this approach hard-wires them, and values not listed will be ignored.

Denis