G
Guest
I am trying to find a way where a grouped field displays items that have zero.
The data I have is organized thus:
Name Points Date
John 10 04/10/05
Bill 20 03/15/05
Tim 25 05/28/05
Bill 30 03/18/05
I have a totals query with Name being Grouped By; Points being Summed and
Date having a criteria (<Date())
In this case Tim has no points but I would like it to show that Tim has 0 in
the query result. I would like to see John 10; Bill 50 and Tim 0 as the
result.
I apologize if the description above is anguished.
The data I have is organized thus:
Name Points Date
John 10 04/10/05
Bill 20 03/15/05
Tim 25 05/28/05
Bill 30 03/18/05
I have a totals query with Name being Grouped By; Points being Summed and
Date having a criteria (<Date())
In this case Tim has no points but I would like it to show that Tim has 0 in
the query result. I would like to see John 10; Bill 50 and Tim 0 as the
result.
I apologize if the description above is anguished.