Re: Consecutive Date Query

I'm sorry but I don't see how you can do this without any code or a
complicated series of queries. You can do this somewhat easier in Excel
because it allows comparison with the other records (e.g. if cell <> previous
cell + 1then "Start" and if cell <> next cell - 1 then "End"). In any event,
you may have to figure out how to deal with weekends and holidays.

T wrote:
I have a datebase where im trying to display employees who have taken consecutive Vacation time.(3 or more days). The table has the below data(emplyee ID, Name, Startdate, Enddate). Im thinking I may have to write a function, but would like to keep it as a query

Data:
1,Jon Jones, 2/28
1,Jon Jones, 2/29
1,Jon Jones, 2/30
1,Jon Jones, 5/28
1,Jon Jones, 5/29
1,Jon Jones, 5/30
2, Jill Jones 5/15
2, Jill Jones 5/16
2, Jill Jones 5/17
2,Jill Jones, 5/28
2,Jill Jones, 5/29
2,Jill Jones, 5/30

Results should be:
1,Jon Jones, 2/28, 2/30
1,Jon Jones, 5/28, 5/30
2,Jill Jones, 5/15, 5/17
2,Jill Jones, 5/28, 5/30

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Two Characters, one name
    ... trying to find David Jones. ... specific university and his boss, Jill Jones (from Wales) said, ooh, ... got there he remembered Jill Jones was Jill's married name; ...
    (rec.arts.sf.composition)
  • Re: How to search for a form according to a field other than record nu
    ... Having a "form of the 'Jones' family" sounds like an unusual design. ... You have to use queries to impose some "sort" order. ... If you want a different order, use a query and sort in it. ...
    (microsoft.public.access.forms)
  • Conditional "Is Null" Query Criteria
    ... Question deals with linking tables in queries. ... I'm trying to find all the records that are in "Master", ... If I put "Jones" in the criteria section of query, ...
    (comp.databases.ms-access)