Performing SUM within date range

[evandro]

I have a database containing several fields, which I will use Account, Symbol, NEt Quantity and date.

I set up a new table just to get the result I need, which is the SUM of net quantity for the specific acc and symbol I choose within a date range.

This new table contains the fields acc , symbol, date in , date end, net quant sum.

Acc is the account field from my main table that I choose from a drop down.

Symbol is the same as above.

date in is the date i need to start the query, initial point of the date range.

date end is the end of the date range point.

I need that the net quant sum come out with the sum described above.(SUM of net quantity for the specific acc and symbol I choose within a date range)

If I put a Sum for the net quantity after doing the find, it will come up with the sum for all entries , not only the ones with the data range I wanted to define with date in and date out.

Can Anyone help me?

TKS a lot!

Evandro