Access Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
You're going to have to give some more details. Display them how? Where are
the dates coming from?
 
I have 3 tables (Employees), (EmployeeTask) and (TaskList) with the following fields
Employee
- EmployeeI
- EmployeeNam

EmployeeTas
- EmployeeI
- TaskI
- StartDat
- EndDat

TaskLis
- TaskI
- TaskDescriptio
- TaskSdat
- TaskEdat

Given that more than 1 employees will do a task and that the employees can start on different dates (>=TaskSdate and <=TaskEdate), I want to know in a given date range: Who is doing what

Eg. Requested Date range to search: Start 11/26/03 and End 12/02/0

How many worked on 11/26, 11/27, 11/28, no weekends, 12/01 and 12/0

Searched date range of course will be different, however, each time I want to be able to see day by day who does what

Thanks in advance
Sun



----- Douglas J. Steele wrote: ----

You're going to have to give some more details. Display them how? Where ar
the dates coming from
 
One approach (not the only one) would be to create a table of dates in which
you're interested. Then, join that table to your other tables using
inequalties. You'll have to write the SQL yourself: you can't use the query
builder to do these kinds of joins.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Sung said:
I have 3 tables (Employees), (EmployeeTask) and (TaskList) with the following fields:
Employees
- EmployeeID
- EmployeeName

EmployeeTask
- EmployeeID
- TaskID
- StartDate
- EndDate

TaskList
- TaskID
- TaskDescription
- TaskSdate
- TaskEdate

Given that more than 1 employees will do a task and that the employees can
Click to expand...
start on different dates (>=TaskSdate and <=TaskEdate), I want to know in a
given date range: Who is doing what.
Eg. Requested Date range to search: Start 11/26/03 and End 12/02/03

How many worked on 11/26, 11/27, 11/28, no weekends, 12/01 and 12/02

Searched date range of course will be different, however, each time I want
Click to expand...
to be able to see day by day who does what.
 
The dates are not set dates, they are entries of events...that will always grow
I'm not sure that I understand what you mean to create a table for this

You said there are other ways, can you tell them to me
Can you show me how the SQL would look like? I wouldn't call myself an expert in this area

Much thanks

----- Douglas J. Steele wrote: ----

One approach (not the only one) would be to create a table of dates in whic
you're interested. Then, join that table to your other tables usin
inequalties. You'll have to write the SQL yourself: you can't use the quer
builder to do these kinds of joins

--
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(No private e-mails, please



Sung said:
I have 3 tables (Employees), (EmployeeTask) and (TaskList) with th following fields
Employee
- EmployeeI
- EmployeeNam
- EmployeeI
- TaskI
- StartDat
- EndDat
- TaskI
- TaskDescriptio
- TaskSdat
- TaskEdat
Click to expand...
start on different dates (>=TaskSdate and <=TaskEdate), I want to know in
given date range: Who is doing what
 
Back
Top