Hi,
I've setup a query that compares the difference (in years) between two
date fields (Joining Date & Date Cancelled) and then totals how many
people fit into each category (0 years, 1 year, 2 years etc.).
The query is setup so that it only counts records that have both a
joining and cancelled date.
My problem is that when I remove the totals and view in datasheet
view, it says there are 147 records. But when I add the totals and
view in datasheet view, there is an extra row at the top with no value
but a count of 2:
-2
0-37
1-49
2-33
3-11
4-11
5-3
6-2
7-1
This brings the total up to 149, which is wrong.
I can't attach a screenshot, but here are the details of how my query
is setup (there are 3 columns used - ** indicate field boundary):
Field: *Years: DateDiff("yyyy",[Joining Date],[Date Cancelled])*
*Joining Date* *Date Cancelled*
Table: * * *Past Members* *Past Members*
Total: *Group By* *Count* *Count*
Sort: *Ascending* * * * *
Show: *Ticked* *Ticked* *Not Ticked*
Criteria: * * *Is Not Null* *Is Not Null*
Or: * * * * * *
Could anyone please help me work out why that extra row at the top is
appearing and adding two onto my totals?
Thank you very much!
Shari