Display current year stat on form

[Wylie C]

I have a form that displays records with a bound date field named Statdate
from a table named Statistics
..
I have an three unbound controls on the form that display the current year,
month and week total miles ( from a query). What I want to do is when the
user browses thru the records, the year statistics in the three controls
correspond with the year shown in the Statdate control. Can this be done and
how?

Thanks.

 

[Arvin Meyer]

Several ways you can do it:

1. Using a continuous form, bind the form and the controls to the query.
2. Build a recordset that looks up values from the query and returns them to
the form.
3. Use the DSum() function to return the totals from the query.

Methods 1 or 2 will be the fastest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access