Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-13-2001, 11:54 AM   #1
DRananahan
Member
 
Join Date: Jul 2000
Location: Tucson, AZ
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
DRananahan
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,
Doug

__________________
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
araskas
Registered User
 
Join Date: May 2000
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
araskas
post your query and I will be able to help
araskas is offline   Reply With Quote
Old 11-16-2001, 06:21 PM   #3
jdev
Guest
 
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
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 04:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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