Re: Sending a Pivot Table by Mail

Jerome Ranch <ranchjp@xxxxxxxxx> wrote in
news:a0tca25k3f22f05i64rn11n307cd2flssv@xxxxxxx:

Thanks all
Sending an xls file and then manually making the pivot is not
an option. There are just too many emails and files I send
weekly for me to do this. I am out of town frequently and I
need the automation. Also many of the customers are not "pivot
wise" and so I do not expect them to execute the pivot.

I will try the crosstab again..there are ways to make the
crosstab without using the wizard that I found here that might
allow me more flexibility http://www.datapigtechnologies.com/

Thanks
Jerry

Yes, the Crosstab Wizard is more like the Sorcerer's Apprentice.
Doing crosstabs manually is a snap. Then you can do other things
to expand on that..
I have one query that joins four crosstabs of the same data, to
give me sum, avg, min and max for a year by month, against 30
assemblers.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: Sending a Pivot Table by Mail
    ... Sending an xls file and then manually making the pivot is not an ... There are just too many emails and files I send weekly for me ... Also many of the customers are not "pivot wise" and so I do not expect ... I will try the crosstab again..there are ways to make the crosstab ...
    (comp.databases.ms-access)
  • Re: Is a dynamic crosstab form possible?
    ... If pivot tables and crosstab queries give you what you want and the forms ... Try writing a pivot table or crosstab query ...
    (comp.databases.ms-access)
  • Re: pivot table
    ... I apologize for the name of the query (as it started out as a Pivot Table ... then I tried the crosstab) ... > the cells that are blank in the "crosstab" new table, I cannot add an amount. ...
    (microsoft.public.access.queries)
  • Re: Is a dynamic crosstab form possible?
    ... Now one could open up the query without mods and see ... report will always have controls matched to field names. ... I didn't receive much of a response conserning Pivot tables in Access. ... but a CrossTab will work for me too. ...
    (comp.databases.ms-access)
  • Re: Pivot Table
    ... I don't do pivot tables in Access as I find crosstab queries have as much ... If this solution is for a report, ... It's not a crosstab query, it's a Pivot Table. ...
    (microsoft.public.access.formscoding)