Different Result Set for Select Query and Make Table Query

[fuzzyocelot]

A friend of mine is having a strange problem. When he runs a simple select query on one table, it returns a certain result set containing 31 records. However, when he changes it to a make-table query it returns a different result set. It still shows 31 records but there are lots of duplicate rows and some rows are even missing. The select query seems to show different data each time he runs it.

We're pretty sure it's not the database table (SQL Server 2000) because I can run the same query just fine on my PC. Meaning, it consistently returns the same result set as a select query and as a make-table query. In fact, when he runs the make-table query the data returned is the same as the results I'm getting.

We both have Access 2002 as well and are both running Windows XP.

Any ideas are greatly appreciated.

Thanks!
Rebecca

 

[fuzzyocelot]

Below is the SQL in case anyone wants to know:

SELECT dbo_benefit.employee, dbo_benefit.plan_type, dbo_benefit.start_date, dbo_benefit.stop_date, dbo_benefit.plan_code
FROM dbo_benefit
WHERE (((dbo_benefit.employee)=1));