By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

Comparing Difference (in Years) Between Two Dates & Totalling -Troubleshooting

P: n/a
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
Aug 28 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.