I have a database that contains Items procured for differant projects. I have created a query that works out the delivery time of the items using date recieved - date demanded. I want to group these in a count of items recieved in the following time scales.
1. Less than 3 days
2. greter than 3 less than 7
3. greter than 7
I want to create a crosstab query but require to input my own groups as above.
Help please!
1. Less than 3 days
2. greter than 3 less than 7
3. greter than 7
I want to create a crosstab query but require to input my own groups as above.
Help please!