Different result from same query

[gundie]

I've got this query:

SELECT DISTINCT tblchpreceived.[New Intro] AS Intro, [Pr Pathways Chapter Received Annual Query New].[New Ctr], [Pr Pathways Chapter Received Annual Query Extended].[Extended Ctr], [Pr Pathways Chapter Received Annual Query Updated].[Updated Ctr], [New Ctr]+[Extended Ctr]+[Updated Ctr] AS Total
FROM ((tblchpreceived INNER JOIN [Pr Pathways Chapter Received Annual Query New] ON tblchpreceived.[New Intro] = [Pr Pathways Chapter Received Annual Query New].[New Intro]) INNER JOIN [Pr Pathways Chapter Received Annual Query Extended] ON tblchpreceived.[New Intro] = [Pr Pathways Chapter Received Annual Query Extended].[Extended Intro]) INNER JOIN [Pr Pathways Chapter Received Annual Query Updated] ON tblchpreceived.[New Intro] = [Pr Pathways Chapter Received Annual Query Updated].[Updated Intro];

It's giving me different result from two different machines. Both machines are Win XP running Access 97 (SR-2). One machine is giving me the correct result, while the other gives 0 result. Funny thing is, among 30-40 queries within that DB, only that particular query is giving me problem.

What would cause something like that to happen?

 

[GooGoocluster]

Are there any filters turned on the machine you are having trouble with?

Is the data base on the same network?

Are you using a adp? if so do you have 2 differnt versions on the network?

 

[gundie]

I did not set any filters.

The database is on the same network, there's only one MDB.