Hi all,
I am attempting to do something that I'm not sure is possible, so if there are any alternative suggestions on how to find the end result please feel free to tell me where I should be looking.
Basically I have a form where a start date is inputted (Inputfrm , StartDate) and a form where the end date of the process is recorded (Inspectionfrm , EndDate) and these both record in the table InputTbl as StartDate and EndDate respectively.
I have created a union query which shows a list of all the dates where there is work recorded (WorkingDatesQry and the column of list of unique dates is "WorkingDate"), and as we run a highly varied schedule depending on time of the year and order numbers I cannot just use a query which says Monday-Friday or Tuesday - Saturday.
What I am trying to do is to find the number of days between StartDate and EndDate where there is a date recorded in the WorkingDates query.
How/Would it be possible to go about this?
Cheers!
I am attempting to do something that I'm not sure is possible, so if there are any alternative suggestions on how to find the end result please feel free to tell me where I should be looking.
Basically I have a form where a start date is inputted (Inputfrm , StartDate) and a form where the end date of the process is recorded (Inspectionfrm , EndDate) and these both record in the table InputTbl as StartDate and EndDate respectively.
I have created a union query which shows a list of all the dates where there is work recorded (WorkingDatesQry and the column of list of unique dates is "WorkingDate"), and as we run a highly varied schedule depending on time of the year and order numbers I cannot just use a query which says Monday-Friday or Tuesday - Saturday.
What I am trying to do is to find the number of days between StartDate and EndDate where there is a date recorded in the WorkingDates query.
How/Would it be possible to go about this?
Cheers!
