Unanswered: Getting the past 3 months and 6 months data in Access Query
I'm trying to understand these code here, I got them from an existing queries in the access database.
This is for the 3 months table
SELECT RG_pledger_view.FirstOfChannel AS Channel, Count(RG_pledger_view.rc_donor_id) AS Base
WHERE (((DateDiff("d",[MinOfrn_create_date],#3/1/2012#)) Between 80 And 395))
GROUP BY RG_pledger_view.FirstOfChannel;
6 months is identical except it says Between 170 And 485 after the datediff.