Hi,

I have a form (unbound) with a start date and an end date to get a report to give me the members on leave for that period. Every thing works fine but when a member is on leave from 2014/06/01 to 2014/06/10, and I enter a start date of 2014/06/03 and end date of 2014/06/04, I get a blank report. What I want instead is for the report to give me the members name because he was on leave in that time frame. I hope it makes sense. I want access to store all the days between 2014/06/01 and 2014/06/10 and not just the two dates entered in the start and end dates.

I have a table [tbl_Leave_Records] with the [leavestartdate], [leaveenddate], [leavetype] and [paynumberFK]. I have a query [qry_Leave_Records] from that table, the unbound form [frm_Leave_Dates] to filter by start date, end date and paynumber and a report [rpt_Leave_Records] that gives me the results.

Thank you