Please Help. I am tring to get the Month to date, year to date and week to date total in a query. I added a parameter for a date range. Instead of giving me the mtd, wtd, ytd, I get the whole months daily total. Can someone tell me what query caculation do I need to just get one number instead of daily numbers?

You might look at a crosstab query for this. What you need to do is use the Datepart function to extract the Year, month and week from the date field. Then uses those values to group your records.

Please don't start new threads on the same topic.
http://www.access-programmers.co.uk/forums/showthread.php?p=429613#post429613