Mar 7th, 2010, 10:43 PM
If this is just for viewing records by the week, then all you need is a relationship. It can even be a self-join relationship (there's no point in having a table of just dates). Use a global field to select an arbitrary date, have two calculation fields to determine the week's starting and ending date, and define the relationship to include only records in that week.