Access 2003 Pivot Table: Use sum in sub forum

[Blakeseven]

Hi all,
I have 2 pivot Table sub forms in a main form. What I need to do is cresate a sum from both totals. This of course needs to chande based on any filter applied.

Can this be done ?

Thanks

 

[Blakeseven]

bump

 

[lespaul]

what is the SQL of the queries that get the 2 pivot tables sub forms?

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[Blakeseven]

This form was biult with the pivot table wizard, so I am not sure.

 

[lespaul]

in the form design view you should be able to look at the properties of the sub form. One of the properties will be source....that should contain the SQL for the source of the sub form...

 

[Blakeseven]

select pipeline * this is the table the data is coming from

 

[lespaul]

ok

SELECT Pipeline *

is not a valid SQL statement....if pipeline is the table it should be something like:

SELECT * FROM Pipeline

(you need a FROM clause)

now that query will return every record with every field from that table....

a pivot query usually has a PIVOT clause as well...