DATE SENSITVE IN ACCESS 2000

J

John Leight

I am trying to find out if I can put a date in a query and
have a specific record removed from that query on that
date. For example, if I am using dates for when someone
is away from work. I would like this record to disappear
from the query after the return to work date. Help me
please.
 
P

Pieter Wijnen

I Guess a Table containing absentees would do the trick

EMP (table)
EMPLID autonumber
Name text
.....

ABSENT (table)
EMPLID Long int
FROMDATE Date/Time
TODATE Date/Time

Query
SELECT E.* FROM EMP E INNER JOIN ABSENT A ON E.EMPLID = A.EMPLID
WHERE Date() BETWEEN A.FROMDATE AND A.TODATE

would then give you all employees who are absent today

HTH

Pieter
 
?

???

John Leight said:
I am trying to find out if I can put a date in a query and
have a specific record removed from that query on that
date. For example, if I am using dates for when someone
is away from work. I would like this record to disappear
from the query after the return to work date. Help me
please.
Click to expand...
 
Top