Reports displays all records...I don't want it to (1 Viewer)

[Kill_Switch]

Hey all.

I got a form for stats tracking. A basic report nonetheless.

I have a table called employees, with EmployeeID as the PK and a yes/no for a field with the name "attended"

I have a report that has the employee table as the Source, and 2 values at the moment for it to calculate.

In the # of people textbox. I have the following for the source "=Sum([EmployeeID])" Which works, and returns the total (of 76).

And I have another textbox for the number of people who have attended/sum of people. "=Count([attended])/Sum([EmployeeID])" {along those lines, as the DB is at work and forgot my thumb drive}

And that works fine, 6/76 have attended, and it displays 7.9% (formatted the output of course).

Only problem is, it shows the data 76 times, and I only want it to display once. And I can't see where to set it to single form instead of continuos. Like below.

Total pers        Attended
76                   6 = 7.9%
76                   6 = 7.9%
76                   6 = 7.9%
76                   6 = 7.9%
76                   6 = 7.9%
76                   6 = 7.9%
And so on for a total of 76 times.

I wish to just make it.

Total pers        Attended
76                   6 = 7.9%

Many thanks in advance.

 

[georgedwilkinson]

You need to put your aggregate functions in your query, not in the text box. Then bind your text boxes to the aggregated fields within the query.

 

[Kill_Switch]

alright I'll give that a shot on monday, thanks.