[AccessD] Date Compare

Oops!  Nevermind.  :)

I figured out how to get the between operator to work in the "Select"
statement.  It appears, though, that once you use this....you can no
longer view the query in Design View...only in SQL view????

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


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Wednesday, January 10, 2007 10: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