dcount syntax

[Mitchell_Collen via AccessMonster.com]

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

 

[Duane Hookom]

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.