I am using Access 2002 and I am having problems getting a monthly and yearly total on a Report. My Report Has a Field called (NumWkd) and (DateWkd) The report information is taken from a query. In the reoprt footer I sum all of my data. The problem I am having is one total is for the current month. The second total is year to date. If I put BETWEEN (#06/01/2011#) AND (#06/30/2001#) as a criteria for DateWkd I only get June totals which is fine for the Monthly totals. When I try to get Yearly totals I can only get Junes totals. If I leave out the BETWEEN statement then I only get yearly totals and not monthly totals.I have only been using Access for a short period and I am an old man. Please be simple in your explanation if you are offering help.Thank you