Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 11-13-2001, 11:54 AM   #1
Join Date: Jul 2000
Location: Tucson, AZ
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
CrossTab Query-Force Row Headings

Hello all,

I am having difficulties with a crosstab query. I need to have row headings show for each possible row type - Even if there is no data to display. I have bulit a table with the row headings I need and created a relationship to the table with my data. I have specified in the Query Window to show all records in my row headings table.

It is still not working.

I would appreciate any help as I am under a deadline.

Thank you,

Worry is just interest paid on a debt that never comes due...
DRananahan is offline   Reply With Quote
Old 11-15-2001, 04:14 PM   #2
Registered User
Join Date: May 2000
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
post your query and I will be able to help
araskas is offline   Reply With Quote
Old 11-16-2001, 06:21 PM   #3
Posts: n/a
Click on the column field in the query's design view, go to Properties.
Under column headings type all the names you need in the order you need them to display e.g. "aaa","bbb","ccc" etc. Each one needs to have the " " around it, with a comma between each entry. When you run it, the query will return all the column names you listed even if the cells are empty.
Good luck

  Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 05:55 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World