Solved

Forcing Crosstab Query to show columns with no data

Posted on 2011-09-27
3
369 Views
Last Modified: 2012-06-27
I'm using a crosstab query to flip data sideways.  But, if a field has no data, then the crosstab doesn't show the "empty" column.

Is there a trick to cause empty columns to show in the query results?

Thanks
0
Comment
Question by:OnsiteSupport
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 36709198
yes, you can force empty column to show, example

hardcoding the pivot columns

pivot [Month] in ("Jan","Feb",........"Dec")


upload a copy of the db..
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36709239
if you have a fixed column names, you can create a table for the column names and use it to produce the empty columns...

see this thread

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21638202.html
0
 

Author Closing Comment

by:OnsiteSupport
ID: 36719799
got it...thanks Cap
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question