Total records for Users in a report

supportt

Registered User.
Local time
Today, 14:32
Joined
Nov 21, 2001
Messages
70
I have setup a new query and it displays all the data I want, but it is not showing up like I would like it to in the report. Basically, the query gets all the tickets from my DB for a given date range. I want the report to show something like this:

USER: TICKETS OPENED:
DAVIDD 129
BILLW 400
ANNK 149

My report is showing the user column names more than once, so it might show DAVIDD several times in the report. And the total number of tickets opened is not showing the correct number either.

Any suggestions would be very much appreciated...

Thanks
 
Are you saying that the query shows the correct data (as you would like the report to show) but the report doesn't?

If so, did you create the report based on the query using the wizard?

From your description, I can't gather exactly what you want do and so much of it depends on how your report is formatted. I guess your description is a little vague.
 
Sorry, I was a little unclear on my question

The query shows the data I need, but I don't want to see, for example 100 separate records for DAVIDD. I only want to see DAVIDD name listed once in the report and his total tickets for the month.

Basically the query shows the data needed in my report, except it shows all the records individually. In other words, each ticket is a single record in the query, I would like my report to show the records grouped by users and then have a single total number of tickets that the user created. see example below:

This is how I would like the report to look, data wise. This is based on a data range for a month of records.

USER: TOTAL TICKETS CREATED:
DAVIDD 3245
KIMW 1023
JOHNR 2399
GLENNP 1500

Hope this helps out...

thanks
 
To keep it simple, let's just assume your tables contains only 2 fields, name and tickets. Maybe that's the case anyway.

Create a report with the table as its record source.

Go into sorting & grouping, select the Name field and set group header to Yes. The report will generate a new header for grouping by name.

Inside the Name header, add 2 text boxes. Set the control source of the first one to the Name field.

Set the control source for the 2nd text box to:

=Sum(Tickets)

...and make sure the name of the control is anything but "Tickets"


That should do it.
 

Users who are viewing this thread

Back
Top Bottom