Unbound ctrl link to year year grouping

W

Wylie C

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.
 
D

Duane Hookom

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

Wylie C

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...
 
D

Duane Hookom

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...
 
Top