Re: Query To Find Records As Of Specified Date
From: deko (www-dot-clearpointsystems-dot-com_at_nospam.com)
Date: 10/29/04
- Next message: Allen Browne: "Re: Multiple Table Creation in Access"
- Previous message: Salad: "Re: Query To Find Records As Of Specified Date"
- In reply to: Sue: "Re: Query To Find Records As Of Specified Date"
- Next in thread: Allen Browne: "Re: Query To Find Records As Of Specified Date"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 05:34:03 GMT
you're awful bitchy for someone receiving free advice.
"Sue" <smillen@notmyemail.com> wrote in message
news:_zigd.11122$5i5.4767@newsread2.news.atl.earthlink.net...
> No!
>
> "deko" <www-dot-clearpointsystems-dot-com@nospam.com> wrote in message
> news:4Rhgd.36329$QJ3.5091@newssvr21.news.prodigy.com...
> > > DateHired will never be greater than DateLaidOff.
> >
> > Does DateLaidOff become null when someone is rehired? If so, this might
> > work:
> >
> > SELECT tblEmployement.EmployeeID, tblEmployee.FirstName
> > tblEmployee.LastName FROM tblEmployement INNER JOIN
> > tblEmployee ON tblEmployement.EmployeeID=tblEmployee.EmployeeID
> > WHERE DateHired < userDate AND DateLaidOff > userDate
> >
> >
>
>
- Next message: Allen Browne: "Re: Multiple Table Creation in Access"
- Previous message: Salad: "Re: Query To Find Records As Of Specified Date"
- In reply to: Sue: "Re: Query To Find Records As Of Specified Date"
- Next in thread: Allen Browne: "Re: Query To Find Records As Of Specified Date"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
