Hi Jim, you have to make a Grouping Query and count how many times an employee number appears using the count function. See the SQL String below for example
SELECT Count(InjuryTable.EmpNo) AS CountOfEmpNo, InjuryTable.EmpName, InjuryTable.EmpNo FROM InjuryTable GROUP BY InjuryTable.EmpName, InjuryTable.EmpNo HAVING (((Count(InjuryTable.EmpNo))>=3)); Change the table name 'InjuryTable' to your table name and change the 'EmpNo' field name to the one matching your table, also change the EmpName field to your employee name field and paste the string into a query and run it. Regards, Duane Hennessy. Bandicoot Software Tropical Queensland, Australia (ABN: 33 682 969 957) Want Increased Productivity? http://www.bandicootsoftware.com.au --- In AccessDevelopers@yahoogroups.com, "luvmymelody" <[EMAIL PROTECTED]> wrote: > > I have a database that is for Employee injuries. How do I make a query > to report back more than 3 occurences of an EmpNo? I want to find out > if an employee has been hurt more than 3 times. > > Jim Wagner > Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
