=Sum([Sum of Acres]) syntax

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

Guest

Hi all

I am designing a report. This report should show current acres from 2004 and the old acres from 2002. I have 2 separate queries, one for 2004 and one for 2002. Does anyone know the proper syntax to create a sum on the 2002 query? I am trying to use =Sum([2002_SE Table]![Sum Of ACRES]) but no success

Thank you
 
The simplest method is to probably use:
=DSum("[Sum Of Acres]", "[2002_SE Table]")


--
Duane Hookom
MS Access MVP


Ali said:
Hi all,

I am designing a report. This report should show current acres from 2004
Click to expand...
and the old acres from 2002. I have 2 separate queries, one for 2004 and
one for 2002. Does anyone know the proper syntax to create a sum on the
2002 query? I am trying to use =Sum([2002_SE Table]![Sum Of ACRES]) but no
success.
 
Back
Top