Unbound ctrl link to year year grouping

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

Guest

I have a report which groups statistics by year. In the detail section I want
to put an unbound control that totals the numbers in the field Elevation from
the table tblMoreStats for the year shown in the grouping header. Would like
some help if possible. I have tried =Sum([tblMoreStats]![Elevation]) and it
asks me for a paramter value.

Thank you.
 
Duane,
It is an unbound control not associated with a table or a query.

Duane Hookom said:
If Elevation is a field in the report's recordsource, just use:
=Sum(Elevation)

--
Duane Hookom
MS Access MVP


Wylie C said:
I have a report which groups statistics by year. In the detail section I
want
to put an unbound control that totals the numbers in the field Elevation
from
the table tblMoreStats for the year shown in the grouping header. Would
like
some help if possible. I have tried =Sum([tblMoreStats]![Elevation]) and
it
asks me for a paramter value.

Thank you.
Click to expand...
Click to expand...
 
Try:
=DSum("[Elevation]","[tblMoreStats]")

--
Duane Hookom
MS Access MVP
--

Wylie C said:
Duane,
It is an unbound control not associated with a table or a query.

Duane Hookom said:
If Elevation is a field in the report's recordsource, just use:
=Sum(Elevation)

--
Duane Hookom
MS Access MVP


Wylie C said:
I have a report which groups statistics by year. In the detail section I
want
to put an unbound control that totals the numbers in the field
Elevation
from
the table tblMoreStats for the year shown in the grouping header. Would
like
some help if possible. I have tried =Sum([tblMoreStats]![Elevation])
and
it
asks me for a paramter value.

Thank you.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top