Pivot query as report source

[Leo]

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

 

[Guest]

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

 

[Duane Hookom]

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.