a guest May 23rd, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. To select dates in a quarter or over more than one quarter use the following SQL
  2. 5) Create query as follows
  3. SELECT [DayNo] & "/" & [Month No?] & "/" & [Year No?] AS MonthDates
  4. FROM MonthTable, QtrTable
  5. WHERE [QtrTable.QtrNo] BETWEEN [Start Qtr?] AND [End Qtr?];
  6. 6) create second query
  7. SELECT CDate([MonthDates]) AS DaysInMonth
  8. FROM YourQuery
  9. WHERE (((IsDate([MonthDates]))=True))
  10. ORDER BY CDate([MonthDates]);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand