Search results

After I enter the hours for a user w/ 2 titles I run the query to see how many users and titles are left. The query should show the user name just entered and the remaining title. Currently, it doesn't show the user at all. In other words: User: Bob Titles: title 1, title 2 Before entering...

ByteMyzer, Thanks for the input. I tried, but w/out success. I also tried your query with the "WHERE NOT IN" clause. Any other ideas. This doesn't seem like it should be this complicated, but ... Ken

How about this: strSQL = "SELECT cb1 FROM Last Cat WHERE catpathid = 5" Me.combo1.rowsource = strSQL You may need to place Last Cat in quotes since there is a space in the table name. Ken

Hello, I am having a problem getting the expected results from a SQL subquery. The point of the query is to return all users and user titles that have not been entered into the database for the current month (not in tblHours). Some users have 2 titles and some just one title. Each month we...