Previously i had help with some of my queries on my system im designing but i need one more thing...
im trying to create a query where it as for a specific date (i know how to do this) between and to ad then brings back each date between those dates a record has that date on.
if i have 6 records with a date on them for the 6/10/08 and 3 for the 7th and 0 for the 8
then in my query it should show the result DateTotal
and if possible then have a total named the week number which automatically updates and the um of the total for that week at the bottom