Search results

Without using a cross-tab query, is there anyway I can display the rows as columns on a report...ie printing them horizontally, instead of vertically? Thanks.

In a cross-tab query, I want to hardcode the column names in the properties. But I want only those columns that contain data to show up when queried. Can I somehow put and IIF statement inside the PIVOT command? Something like: if a column containes data based on my query pivot on that column...

I have created a crosstab query based on this table. VALUES __________ Oil_ID (PK) Property_ID (PK) Col_Heading (PK) (*112 distinct values) Row_Heading (PK) Col_HeadingUnit Row_HeadingUnit Values Oil Name Property Name The crosstab query looks like this so far. PARAMETERS [Forms]![Values...

http://www.access-programmers.co.uk/forums/showthread.php?t=102156 Should've read the forum first. Thanks :)

This is my first time posting here and I hope you guys can help me. I have a problem with using a crosstab query. My original table looks something like this VALUES Oil_ID (PK) Property_ID (PK) Col_Heading (PK) Row_Heading (PK) Values Oil Name Property Name I made a crosstab query with...