Total query using date range.

N

NoviceIan

I'm trying to set up a query which will total up all annual leave hours a
staff member has taken between a certain date range. I'm using the Between
And Functions and it does list the relevant instances but it wont total the
hours.


However if I remove the date field it totals up just fine.

Where am I going wrong?

Ian
 
J

John Vinson

I'm trying to set up a query which will total up all annual leave hours a
staff member has taken between a certain date range. I'm using the Between
And Functions and it does list the relevant instances but it wont total the
hours.
Click to expand...

Change the Totals row value for the date field you're using as a
criterion from "Group By" to "Where".

John W. Vinson[MVP]
 
N

NoviceIan

Thats great it works fine now, thanks very much.

John Vinson said:
Change the Totals row value for the date field you're using as a
criterion from "Group By" to "Where".

John W. Vinson[MVP]
Click to expand...
 
Top