Report question on Count and Groupby (1 Viewer)

[magster06]

Hi all,

I am hoping that someone will be able to help me with my problem. I have a report that I am trying to show data for the current year, but with a record count.

So, for example: I have 3-OVI, 3-Conduct Unbecoming, and 3-Did not transport for the current year.

When I run my report, it will show the above data for the current year, but in this format;

OVI-1
OVI-1
OVI-1
Conduct Unbecoming-1

and so on.

What I would like is;

OVI-3
Conduct Unbecoming-3
Did not transport-3
Total-9

If I take out the date code for the current year in my query, then I get the desired results but I get all data.

If I leave the date code in, then I get the data for the current year but I get the first example above.

Forgot to show my report, I'll attach that tomrrow.

 

[JHB]

...
If I take out the date code for the current year in my query, then I get the desired results but I get all data.

Change the "Group By" to "Where" for the date field, remember to clear the check box.

 

[magster06]

That did the trick!

Thanks JHB!!

 

[JHB]

No problem.