Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Forcing Crosstab Query to show columns with no data

Posted on 2011-09-27
3
Medium Priority
?
392 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

886 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