I have an access query that contains two dates (Period Start, Period End) and I am looking to calculate/display the the total number of weeks and the remaining days, ex. (10/1/2020 thru 10/17/2020 = 2 weeks, 3 days). I have been able to calculate the weeks but it doesn't show the remaining days "NumWeeks: DateDiff("ww",[PERIOD START],[PERIOD END])". Ideally I would like to have the weeks and days in separate fields(to match mail merge document form), but if it's in the same filed I can just set something up to separate it myself, Anything helps at this point. Thank you in advance.