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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jrjoneseng
- Order by date
-
Crosstab reports...I think?
Duane, Where is the setting to adjust the column headings to show all months even if there is no data?- jrjoneseng
- Post #7
- Forum: Microsoft: Access Reports
-
Crosstab reports...I think?
Duane, Thanks. That worked great! Okay, now one follow on...any ideas how to show extra months across the top of the table when there is no data for those months yet? For instance, assume you are in July and have the new table created by the union and crosstab queries. You would have columns...- jrjoneseng
- Post #5
- Forum: Microsoft: Access Reports
-
Crosstab reports...I think?
Duane, I can send more when I get into the office in the morning, but will try to describe better. My table called "stewardship" contains the following fields: -month - numerical month -year - yyyy -Active - records number of active projects summarized from a different table for the month...- jrjoneseng
- Post #3
- Forum: Microsoft: Access Reports
-
Crosstab reports...I think?
I am having trouble with an Access 2007 report and/or query. I think I want to do a crosstab type of report, but it is different than the examples that I have found. This may be a table design issue, but I've inherited that...so: -I have a table that has fields for year, month, active...- jrjoneseng
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
