Year to date total Help

[Jim]

Hello,
I'm trying to make a Check Stub/Year to Date report for a payroll form. All
the check stub data works as expected, but the year to date portion only
shows the totals for what ever week is being printed at the time and not
year to date, unless I tell it to sum the columun. But if I do that, then it
adds all the figures instead of just the ones from the beginning of the year
to the ending date on the check stub. Does anyone have any ideas on how to
fix this? I'm using Access 2003.
Thanks

Jim