Date Range and Count Formula Help

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

I have a query that has a date referred field. I have a report that I'm
building that counts the ytd referrals and I need to create a formula that
counts the previous 30 days referrals. I've tried everything and nothing is
working. Can I create a formula that pulls the previous 30 days of referrals
and counts them? I'm not sure how to create this formula.
 
Did my post yesterday not do what you wanted?

SELECT Sum(IIF([Corporate Investment Services Referral Tracking].[Date
Referred] Between Date() AND DateSerial(Year(Date()),1,1), 1,0)) AS ytd,
Sum(IIF([Corporate Investment Services Referral Tracking].[Date Referred]
Between Date() AND DateSerial(Year(Date()),Month(Date()),1), 1,0)) AS mtd,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access - Is it possible to repeat fields in a form? 1
mtd and ytd formula issues 4
Excel Formula - Count Dates from another Sheet 8
Excel Date Count 2
Excel Msgbox runing beyond posted cell range. 1
Summing days that match a criteria and date 3
Combining Date queries 1
calculating averages 1

Back
Top