RE: Capturing an employee in a team at a point in time
- From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
- Date: Tue, 13 Feb 2007 09:22:09 -0800
=?Utf-8?B?Um9kIFBsYXN0b3c=?= <RodPlastow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in news:FC3FE5E0-5BA6-4ABD-A504-8156DB9A62C8@xxxxxxxxxxxxx:
WHERE NZ([DateEnd],[MyDate]) >= [MyDate]
WHERE DateEnd IS NULL OR DateEnd >= MyDate
.... has the advantage of saying what it means and working in all database
systems
HTH
Tim F
.
- Follow-Ups:
- Re: Capturing an employee in a team at a point in time
- From: Allen Browne
- Re: Capturing an employee in a team at a point in time
- References:
- Capturing an employee in a team at a point in time
- From: raphozs
- RE: Capturing an employee in a team at a point in time
- From: Rod Plastow
- Capturing an employee in a team at a point in time
- Prev by Date: Re: Normalizing - HELP!
- Next by Date: Re: Table to report design
- Previous by thread: RE: Capturing an employee in a team at a point in time
- Next by thread: Re: Capturing an employee in a team at a point in time
- Index(es):
