DATE SENSITVE IN ACCESS 2000

  • Thread starter Thread starter John Leight
  • Start date Start date
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stored date is not being recognised 1
Date search query 0
Using Date parameters in select queries Access 2003 5
Between Dates or All Dates if No Date Entered 3
MS Access Date/Time Calculation After Midnight 1
Connecting Text Box in Query Criteria 4
date range in a query 2
DSum and date as criteria 3

Back
Top