[AccessD] Date Compare

Subqueries, posted a tutorial a few weeks ago, same process you used to get
the salary levels during pay periods.

Drew

-----Original Message-----
From: Keith Williamson [mailto:Kwilliamson at rtkl.com] 
Sent: Wednesday, January 10, 2007 9:58 AM
To: Access Developers discussion and problem solving
Subject: [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/> 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com