6 Replies Latest reply on Oct 30, 2006 6:49 PM by azadisaryev

    query problem

      I have an access database set up to allow multiple people per ticket number. I have the attached code to pull the data. The problem is that it only pulls one person even though there are 6 listed in the database. Any idea why this is? When I do a COUNT(tblTripTransactions.EmpID) I get the number 6 returned so it does know there are 6. Could the problem be that I need a loop around the select statement to be able to pull all 6 employee id's? I guess what I really need to do is get the empid in a string like (12,23,34,45) from the query.