Pivot Table Question

[hollarindy]

I have exported the data from a table in my database into excel and created several pivot tables with the data. Is there a way to either incorporate the pivot tables into my database or recreate them in the database itself?

 

[pbaldy]

Play with the crosstab query wizard and see if you get the desired results.

 

[hollarindy]

Alright My post-Stroke brain is letting me down. I figured out how to display the data I want with a cross-tab query however, there is soooo much data I need a way to prompt the user for what they want. I tried using the =Like [enter criteria] & "*", but cross-tab queries don't like that. Any suggestions?

On a side note I did stubble onto the pivot table function it is under forms. It is kind of a pain to figure out but, once you get started it is fairly functional. Not very astetic though.

 

[pbaldy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;209778

Haven't used the option under forms.