D
donns.fearn
Guest
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!!!!
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!!!!