K
KenY
Hi
I am trying to give wider access to an Access database using a pivot table
on a data accesss pages through a browser. I can link to the database on a
server and create a Pivot Table based on a single query. However, I find
that when I try to generate a pivot table with fields that are defined in a
query in the database, I cannot reflect these fields in the pivot table.
Example.
one query has data about events on multiple machines (machine ID, feature,
event type, diagnostic data, date and time)
a second query has calculated information about the machines - type - based
on the value of 'feature' (machine ID, machine type)
From this I want to be able to create a pivot table on the data access page
- using all the fields in the first query, plus the machine type in the
second query. When I try to build this in design view, the 'machine type'
field is not made available to me.
How do I make the field appear in the Field List so that I can drag it into
the pivot table?
If I can't do this directly, my thought is that I would have to compile and
export a new table - trouble is that this becomes very inefficient in terms
of resources (it is the way I would do it in Excel, but repeating the same
information for every event becomes very inefficient when dealing with a
large number of events)
I would appreciate any help that you can give me.
Thanks
I am trying to give wider access to an Access database using a pivot table
on a data accesss pages through a browser. I can link to the database on a
server and create a Pivot Table based on a single query. However, I find
that when I try to generate a pivot table with fields that are defined in a
query in the database, I cannot reflect these fields in the pivot table.
Example.
one query has data about events on multiple machines (machine ID, feature,
event type, diagnostic data, date and time)
a second query has calculated information about the machines - type - based
on the value of 'feature' (machine ID, machine type)
From this I want to be able to create a pivot table on the data access page
- using all the fields in the first query, plus the machine type in the
second query. When I try to build this in design view, the 'machine type'
field is not made available to me.
How do I make the field appear in the Field List so that I can drag it into
the pivot table?
If I can't do this directly, my thought is that I would have to compile and
export a new table - trouble is that this becomes very inefficient in terms
of resources (it is the way I would do it in Excel, but repeating the same
information for every event becomes very inefficient when dealing with a
large number of events)
I would appreciate any help that you can give me.
Thanks