Please explain the structure of your tables and perhaps post the SQL from the Record Source of your report.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of sandniel Sent: Monday, January 30, 2006 7:46 PM To: [email protected] Subject: [ms_access] Count Function I have been trying (unsuccessfully) to use the count function to count groups. For example, the Report is grouped by student, followed by what classes each student has taken from me. When I use the count function, it'll count a student 4 times, if they've taken 4 classes from me. Your help will be greatly appreciated. Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
