I have a table that has a date field, called DateOf, in. What i am trying to do is this.
I need a query to show me what records are 0 to 7 days old(1 week old), 8 to 14 days(2 weeks old), 15 to 21 days old(3 weeks), 22 to 28days(4 weeks), and anything over 28 days old.
So the result i am after...