Total query using date range.

[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

 

[Van T. Dinh]

Uncheck the "Show" option in the column for the date.

 

[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.

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

John W. Vinson[MVP]

 

[Guest]

Thats great it works fine now, thanks very much.

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

John W. Vinson[MVP]