I have a report that when run it br

[greysquirl]

I have a report that when run it brings up a form that allows the user to select from a combo box what employee name; which each has thier own (EmpID: AutoNumber) they want viewed on the report. The whole thing is based off a query that when run has the criteria . . . .[forms]![ParamForm]![SelectEmployee] placed in the EmpID portion of the query. Meaning that in the combo box where the user would select an employee to view I could make it so only one instance of the employee's name would show up by using the SELECT DISTINCT statement. Now. . . .my question is I want another report that will generally do the same thing except I want to run the report based on the department. Now each department doesn't have it's own unique (EmpID or DepID: AutoNumber). And when I run the report it shows several instances of the same department in the combo box. Should I create an AutoNumber column specifiaclly for the department? Or is there another way to make this happen without doing that????

If you can understnad this jumbled mess please help me. . . .

 

[AccessSQLUser]

For the rowsource of the department combobox, use the following select statement:

Select [Dept] From [Table1] GROUP BY [Dept]