Count Consecutive Dates

L

Laudrup

I have a database that allocates people to jobs, which is based on
the
Resource Scheduling database.

I would like to show on a Form the current amount of shifts an
employee has worked, by counting consecutive dates from a given date
(ScheduleDatetxt on the form).

Relevant tables used in the form
Employees
Employ_Ref (text)
Surname....
ScheduleDetails (Where jobs allocation is saved)
ScheduleDetailsID
ScheduleID
Employ_Ref (text)
Schedule (job date is saved)
ScheduleID
ScheduleDate

Is there anyway I can do this using VB or SQL? Any help would be
greatly
appreciated.
 

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

Count Dates 7
Check Dates 2
Reference Errors Problem 2
MainForm(weekly) detail of week sched. in Subform 2
SQL to determine Start Date and End Date for consecutive dates 1
Table and form design 0
Autofill subform when move to new record on Main form 30
Combo Box Problem 1

Top