Total query using date range.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
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...
 
Back
Top