I am running a query that will tell me how many jobs we have open/closed/fixed and dealing with at the end of every week(on a friday). At the moment I have to keep manually entering the dates (ie between 22/04/2002 and 26/04/2002) to get data from just that week. How can I do this so I dont have to keep manually entering it myself?? Ideally working on the current date (it will be a friday) and -5 (to get back to monday or something)..

Also at present i have as follows:

closed 1
open 1
closed 1
closed 1
dealing with 5
but I wish to group as follows:

closed 3
delaing with 5
open 1 to display in a report

How do i group it together I have done everything!!!

Your help would be appreciated....i am not very good at access so as basic as possible pls!!!!

if you e-mail me a copy of you database i'll fix and e-mail back to you