Hi MIke

Thank you so much for your response, BUT,I will really like to create a parameter Query... Given the user the flexibilty to choose the date range. Find below ..

I am presently working on a database using Access 2007. I was able to get the total sum for a particular account from the first date to the last date. But i couldn't get the total sum of between a date range.
Take for example:
Acc_Number...

I have two date fields : start_period and end_period, i need to find the total of amount field within a date range