Question about using DSUM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sum data in a column by date by property. My list of
properties is in one table, and the data I wish to sum and the corresponding
dates are in a second table. When I run my query it is summing all the
properties together and placing this "super total" in each cell for the
individual properties.

How do I get Access to sum by date, by property??

This is my current query: Expr1: DSum("[OIL]","ac_product","[p_date]>
1/1/2004")
-The "ac_product" table contains the column I wish to sum.
- The property "ID's" are in a seperate table "ac_property"
- The "ac_Product" table also includes a column of identical property ID's

Thanks.
 
I am trying to sum data in a column by date by property. My list of
properties is in one table, and the data I wish to sum and the corresponding
dates are in a second table. When I run my query it is summing all the
properties together and placing this "super total" in each cell for the
individual properties.

How do I get Access to sum by date, by property??

This is my current query: Expr1: DSum("[OIL]","ac_product","[p_date]>
1/1/2004")
-The "ac_product" table contains the column I wish to sum.
- The property "ID's" are in a seperate table "ac_property"
- The "ac_Product" table also includes a column of identical property ID's

Thanks.
Click to expand...

Include the PropertyID in the third argument (and use # to delimit
your date criterion):

Expr1: DSum("[OIL]","ac_product","[p_date]> #1/1/2004# AND
[PropertyID] = " & [PropertyID])


John W. Vinson[MVP]
 
Thanks..........

John Vinson said:
I am trying to sum data in a column by date by property. My list of
properties is in one table, and the data I wish to sum and the corresponding
dates are in a second table. When I run my query it is summing all the
properties together and placing this "super total" in each cell for the
individual properties.

How do I get Access to sum by date, by property??

This is my current query: Expr1: DSum("[OIL]","ac_product","[p_date]>
1/1/2004")
-The "ac_product" table contains the column I wish to sum.
- The property "ID's" are in a seperate table "ac_property"
- The "ac_Product" table also includes a column of identical property ID's

Thanks.
Click to expand...

Include the PropertyID in the third argument (and use # to delimit
your date criterion):

Expr1: DSum("[OIL]","ac_product","[p_date]> #1/1/2004# AND
[PropertyID] = " & [PropertyID])


John W. Vinson[MVP]
Click to expand...
 
Back
Top