[AccessD] Date Compare

Hi all,

 

Anyone have a solution for how to link two tables with different dates?

 

I have a Payroll Paid table, with field: DatePaid

 

I also have a Timesheet table, with field: TimesheetEndDate

 

The DatePaid field is a bi-weekly date.  The TimesheetEndDate field is
usually a weekly date, but occasionally there is a supplemental
timesheet date.  What I am trying to do is link the Timesheet table for
all dates that fall within the 13 days prior to, and including, the
DatePaid.

 

So, for DatePaid of 11/29/06.....I want to link all Timesheets with a
TimesheetEndDate falling 13 days prior to, and including 11/29/06.

 

Anyone have a solution for that?

 

Thanks kindly, for any help.

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/>