Access Date Range

[Sung]

how do I display the days in a given date range

Thanks.

 

[Douglas J. Steele]

You're going to have to give some more details. Display them how? Where are
the dates coming from?

 

[Sung]

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

 

[Douglas J. Steele]

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)

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

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

to be able to see day by day who does what.

 

[Sung]

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

I have 3 tables (Employees), (EmployeeTask) and (TaskList) with th following fields
Employee
- EmployeeI
- EmployeeNam
- EmployeeI
- TaskI
- StartDat
- EndDat
- TaskI
- TaskDescriptio
- TaskSdat
- TaskEdat

start on different dates (>=TaskSdate and <=TaskEdate), I want to know in
given date range: Who is doing what