EXACT same query, different results

[Bob Thornton]

I run the EXACT same query on 2 different machines and I get 1 record on machine A and 2 records on machine B. The database resides on a network drive. Any ideas why this is happening?? All help is greatly appreciated!!

 

[Bob Thornton]

Yes, everthing, and I mean everything is exactly the same. I open the database on each machine and run the query, changing none of the criteria and I get different results.

 

[msramu]

same query different results

I've got the same issue with my Access query.

Have verified MSysObjects. Data all resides in Access, with some imported from Excel. Access File resides in server.

Results seem to change within a gap of 1/2 hr...HELP!

 

[msramu]

Are you positive that no one is relinking the be? <-- what do you mean here. In any case, I am the only one working on the file.

Let me give an example of what happens to my data. I have a table of 100 customers. I'm tracking their average $ spent across no of days they have been a customer. Based on that I rank them into categories A, B & C.

When I run the query, customer X in the first try goes into category A, but 1/2 hr later when I run the same query again he could jump to category B. No changes are made to the data or query formula.

Dates are involved in the query, but does that make a difference even if I'm running the query within the same day?

Thanks for your help!

 

[JimAhl]

This may be a silly response, but did you check the system dates on the 2 machines. If you are using the current day to calculate your average, maybe one machine has a different date. That would explain the 2 different results.

 

[msramu]

Thanks for that Jim. And yes I did check the time of both machines.

Pat also thank you for your help. I've decided to use a fixed date for my calc. So far it seems fine. But will keep your inputs in mind.