Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Report from a cross-tab

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TD11 - 14 Oct 2004 16:45 GMT
I create a table that contains sales data for my different stores. The table
will contain different store data depending on the limits applied when
creating the table.

I use a cross-tab query to layout the data in columns. The problem is the
table has changing data, the column heading in the cross-tab change. One time
the columns might be stores 1,2 and 3 and the next time it might be stores
4,5 and 6.

Since the column headings can change depending on how the table was built, I
do not know how to write a single report that will print the results of the
cross-tab.

Any suggestions?

Thanks....
Duane Hookom - 14 Oct 2004 16:54 GMT
There are some sample reports that do this at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check out Crosstab.mdb
for the specific solution.

Signature

Duane Hookom
MS Access MVP
--

> I create a table that contains sales data for my different stores. The table
> will contain different store data depending on the limits applied when
[quoted text clipped - 12 lines]
>
> Thanks....
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.