Making calculations between certain dates

[sivega]

Hello all,

I am building a credit tracking database. Each person attends an event and can receive credit in up to 5 different categories. Right now I have a query that adds the number of credits in each category, then adds up the sums of each category (for each person). I am stuck now trying to figure out the best way to only add the credits up during a certain time period. Each person has a specific reporting period, which is a calculated date.

For example: Joe's reporting period is from 5/1/2012-4/30/2014. I want to calculate the number of credits he earned only during that time period.



I tried adding the event date to the query but then it undoes of the sums.

Not sure what's the best way to go about this.......

Thank you!!

[rzw0wr]

Not knowing your SQL.
You may want to look into the Between clause.

http://www.w3schools.com/sql/sql_between.asp

Dale