Hi accessforums.net agen!!
This forum has been amazing, and i'm hoping it will once agen help me solve, what i feel may turn out to be, a very simply query issue.
I have a table that has stores referrals, all assigned a referral date. I would like to create a query that collates how many referrals are received in a month. i have managed to extract the month from the the ReferralDate, using Month([ReferralDate]) and the year using Year([ReferralDate])....but now i'm stuck
As it stands i have 19 referrals, but this query is only showing 15 (as some are on the same day and the query is grouping by ReferralDate)
I would like to group by Month & Year, and to concatenate month and Year....but it comes up as 03-2011 rather than March 2011
Knowing how many referrals are coming in each month is vital information, the fact i'm gettin bogged down in this query is fustrating
pleaaaaase help
l3111, Manchester, UK