G Guest Nov 16, 2005 #1 How can I tell Access to sum the totals for a week or for a month without prompting for a date?