Consecutive Days

[bongmarley]

I am trying to create a report for work attendence but i want to converger consecutive records.

Instead of this
From To #ofDays
01/01/03 01/01/03 1
01/02/03 01/02/03 1

I want this
From To #ofDays
01/01/03 01/02/03 2

Is there a function that will retruieve the record Date from a database annd check for consecutive dates that may help me out with this.

 

[JamesLean]

You are probably better off posting this question in the forum relating to the DBMS you are using.

--James

 

[vanillapod]

You can use datediff if you#re using ms acess...