To select dates in a quarter or over more than one quarter use the following SQL
5) Create query as follows
SELECT [DayNo] & "/" & [Month No?] & "/" & [Year No?] AS MonthDates
FROM MonthTable, QtrTable
WHERE [QtrTable.QtrNo] BETWEEN [Start Qtr?] AND [End Qtr?];
6) create second query
SELECT CDate([MonthDates]) AS DaysInMonth
FROM YourQuery
WHERE (((IsDate([MonthDates]))=True))
ORDER BY CDate([MonthDates]);