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!

How do I delete columns in queries with no data in them?

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hello -

I need some help with querying in Access. I have columns with data and some with out based on what gets filled out in a form. My problem is that I do not want all of these fields in my report if they have no data. I would like to have a program delete the columns as I query and the report gets generated. Is this possible?

Any help would be greatly appreciated.

Thank you,

PTS
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
572
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
594
serino
serino
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
764
TheresAlwaysAWay
TheresAlwaysAWay
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
226
mikrom
mikrom
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
597
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top