If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table List on Data Access Page - Linked Queries
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 -- KenY |
Thread Tools | |
Display Modes | |
|
|