Access - Date Arrangement

Nefarious · 26 Jun 2007 at 15:15

I'm working with a series of dates but want to group data retreived from tables into groups of dates (7 day intervals).

Would I do this in expression builder? Any suggestions would be great!

So far I have queries which draw out the start dates for all groups and the leaving dates for several groups; I have done this by querying serveral tables and am now trying to building a query from those queries which can tabulate into date groups the employees which are leaving (and in another query and table those which are joining)

noob · 26 Jun 2007 at 15:48

Look into the datediff function: -

http://www.techonthenet.com/access/functions/date/datediff.php

Nefarious · 26 Jun 2007 at 16:03

Thanks for replying but that doesn't solve my problem.

Datediff will show me the difference between any two dates that I give it, whether constant or referencing values in a table.

What I want to do is group together values where their dates fall within the same week without having to manually write in each date and create an >= and <= function for each.

Thanks

Nefarious · 26 Jun 2007 at 16:07

From what I can see, the function is so much easier in later versions of access :'( this is driving me a little bit nuts (the package I'm building rather than this particular function)