goldfishhh
New Member
- Joined
- Mar 15, 2003
- Messages
- 45
I hate cross posting, but I think that my first post in the Excel forum was the wrong place...
I have created a form in Access using the Pivot Table wizzard. I then select the proper query (also in access) and select 5 of the 6 fields.
Upon hitting NEXT, Access launches me into Excel where I can apply any formatting I need. I then close Excel and give the new Pivot Table form a name.
Here is the $1,000,000 question. If I decide after I have completed all of my formatting in Excel that I need the remaining field (which I didn't select) how do I do that?
Is there somewhere in Excel where I can tell it that there is another field to use?
I have created a form in Access using the Pivot Table wizzard. I then select the proper query (also in access) and select 5 of the 6 fields.
Upon hitting NEXT, Access launches me into Excel where I can apply any formatting I need. I then close Excel and give the new Pivot Table form a name.
Here is the $1,000,000 question. If I decide after I have completed all of my formatting in Excel that I need the remaining field (which I didn't select) how do I do that?
Is there somewhere in Excel where I can tell it that there is another field to use?