MS Access Help - Microsoft Community

dear all,

i have 2 text box controls (start date1, end date1) of date values. have text box control (week1) representing first week of year.

i need expression code for week1 text box control show number of days in between start date1 and end date1 falling within this week1.

can anybody help to get answer required. advance thanks.

your post little confusing.    

what control source of start date1 , end date1 - or enter dates?

so number in week1 never greater 7 is representing first week of year.

then want "the number of days in between start date1 and end date1 falling within this week1."  

Office / Access / Windows 10 / Office 2013