Calculate total between two dates

[Slab_Rankle]

Hey all, I'm having issues with a Total's query I'm using in my database. The query returns a count and then a sum of the amount of leads we get from a broker. Now, I want to find out how many leads have been given to us between two dates (which are entered by the user). The current Total query I'm using is just bringing back the final value, so it's counting in records that appear after the specified dates, which I don't want. The fields involved in the count query are:

• LeadSource (a text field)
• DateAgreed (Date field)
• CountOfDateAgreed (Number field)

I then sum these values using the following:

• LeadSource
• SumOfCountOfDateAgreed

This has been confusing me for ages so if someone has any ideas that'd be great . If you need me to post the SQL code just let me know and I will .

 

[Brianwarnock]

croteria

Between date1 And date2

Brian