You might want to remove the parameter query and reference a control on a
form. Then create a totals query like:
SELECT Handoutrating, Count(*) as NumOf
FROM [Lots of tables]
WHERE Workshopname= Forms!frmYourForm!cboWSName
GROUP BY Handoutrating;

Then create a subreport based on this query and add it to the existing
Report Footer section.
--
Duane Hookom
Microsoft Access MVP


"Mitchell_Collen via AccessMonster.com" wrote:

Help please. I am trying to count ratings in a report such as:

handout ratings
count total 1s
count total 2s
count total 3s


here is may query:

SELECT workshopID,workshopname, name, dateFrom, dateTo, Contentrating,
Handoutrating, evaluation.[Comments for Content], evaluation.[Comments for
Handout], evaluation.[How may we improve], evaluation.[Describe how it helps]
FROM Lots of tables..
WHERE (((workshop.workshopname)=[workshopname?]));

Please tell me how to do this, i tried a dcount but i am unsure of the syntax.
also is there a select clause also that i need to add to properties in report?



-Misty

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1