Unbound ctrl link to year year grouping

[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 Hookom]

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

 

[Guest]

Duane,
The control is unbound and not associated with a table or a query.

 

[Guest]

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

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

--
Duane Hookom
MS Access MVP

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 Hookom]

Try:
=DSum("[Elevation]","[tblMoreStats]")

--
Duane Hookom
MS Access MVP
--

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

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

--
Duane Hookom
MS Access MVP

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.