Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

empty columns on a report

Status
Not open for further replies.
atadbitslow

atadbitslow

Programmer
Feb 26, 2001
301
US
I have a report that is based on a crosstab query which has several columns, some with data and some without--this fluctuates each month. I would like only the columns that have data in them to print on the report (a heading also)--what is the best way to accomplish this, if any?

Thanks!
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
504
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
568
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
735
caykamanj1966
caykamanj1966
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
356
sxschech
sxschech
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
480
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top