Count Rows query

[Steve in Atlanta]

Please help! I'm trying to write a query that will count the unique occurances of employee ID's on two linked tables (DB2 tables). I have a table that records the country (US or Canada) and employee ID every time the employee logs on to our system. (I'm using the second table to limit the data) What I want to do is count the number of different employees, subtotaled by country, that logged on on a given day. The output would look like:

US 350
Can 75
Total 425

Which would indicate that on the day in question 350 different US employees and 75 different Canadian employees logged on. In design view when I add "Count" under employee ID I get an "ODBC - Call Failed" error. If it's easier to do this with a report that would be fine too.

Thanks

 

[Norie]

Right click and select totals to get counts and grouping.

 

[Steve in Atlanta]

When I do that I get an 'ODBC - call failed' error as follows:

[IBM][CLI Driver][DB2] SQL0111N The column function "" does not include a column name. SQLSTATE=42901 (#-111)

I have the employee ID column set to 'Count' and the other three columns set to 'Group By'. I have two of the columns set not to display. The two that I am displaying are the Country code and employee ID