note that From, TO are reserved words and should not be used for field names (they are part of the SQL language) Also it is bad practice to have spaces in names
However if you create a table called tblNums with a single numeric field called num and populate that field with the values 0 to 9 (more if you need a more than 9 days between your from and to dates)
then use this query (assuming you have named the field and table as above)
Code:
SELECT Sum([DAILY APR].APR) AS SumOfAPR
FROM [DAILY APR], TIMESHEET, tblNums
WHERE (((tblNums.num)<=DateDiff("d",[from],[to])) AND (([DAILY APR].mdy)=[from]+[num]));
it produces .00060409 as your result