Currency Sum problem with date criteria

[dazstarr]

Hi

Can someone help me with this please.

I have 3 fields in a table - Pupil ID, Date and Price.

I have criteria on the date field - between x and x date.

What I would like is the sum of the price broken down by Pupil ID between the inputted dates.

I have set the Grouping property of Price to SUM and the Pupil ID to Group By. I have disabled the 'Show' on the date field so the query only needs to output 2 fields.

The problem I am getting is that is doesnt seem to group the pupils. I get 2 rows with the same pupil (I have 2 records with 2 different prices for that pupil). If i remove the date field and criteria - it works fine but doesnt give me what I need.

Please can someone help me with this?

Many Thanks

 

[Brianwarnock]

Did you leave groupby on the date field, make sure it is where.

Brian

 

[dazstarr]

Thanks Brian

I knew it was something simple!!

Works great.

Thanks again