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 / March 2005

Tip: Looking for answers? Try searching our database.

Pivot query as report source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leo - 17 Mar 2005 16:13 GMT
Hello. I have a pivot query as source of a report

Here's what my issue is:

I have a specific field marked as Column Heading

So what I do is I select all the names from this field and put them as
column heading, for example:

Name1      Name2     Name3   Name4..........
123.23      234.56      2345.7    567.98

However my query will only return the fields that are present.....so if
Name1 and Name2 are in the table then they'll show up in my query, but Name3
and Name4 will not. The problem is that I still ned these
names to show on the report, with a value of at least 0 or - (dash)

The reason is that the data in thwe source table will change, so for example
Field3 and Field4 might get values and need to be automatically showing in
the report. It's not possible for me to track the changes (adding/deleting)
of information to the database and adjust the report that way

So is there a way to show those fields in a report or whatever other way
someone might know? I really really appreciate your help

Thanks,

Leo
KJGinNC - 18 Mar 2005 15:06 GMT
Leo,

I know I've seen similar posts during my searches for other information.  So
you might want to look around a bit.  

However, I just got the Access 2000 Developer's Handbook Vol 1 and Chapter
10 page 727 is "Creating a Report Based on a Crosstab Query".   If you can
get a hold of the book it should be very helpful.

HTH

Karrie

> Hello. I have a pivot query as source of a report
>
[quoted text clipped - 24 lines]
>
> Leo
Duane Hookom - 18 Mar 2005 15:33 GMT
If the full list of names won't change very often, you can add all names
into the column headings property.

If they might change and you don't want to change your query and report the
optimum solution is in the Crosstab.mdb found in a sample download from
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Signature

Duane Hookom
MS Access MVP
--

> Leo,
>
[quoted text clipped - 42 lines]
>>
>> Leo
 
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.