Diff Query Results on different PCs

[SPG]

Hi All,

I have a qry1 which calculates Sum(Num01)
I have another qry2 which has qry1 and other queries.

When executing qry2, it shows values of Sum(Num01) from qry1 in some PCs and
does not show on other PCs.
( I guess it is not able to load the data of qry1 on some PCs)

But when I put a dummy text field (Dummy:"Dummy") on qry1, qry2 works fine
on all PCs.

Weird!!!! Can anybody explain how can I solve the above problem.
(I am running on MS Access 97 on different PCs with Win XP.)

Thanks in advance.

SG


*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***

 

[SPG]

Hi,
The problem is weird and the solution is illogical.
I would be grateful if somebody could please help me to sort out the problem
in a logical way.
Thankyou.
SPG

Hi All,
I have a qry1 which calculates Sum(Num01)
I have another qry2 which has qry1 and other queries.
When executing qry2, it shows values of Sum(Num01) from qry1 in some PCs
and does not show on other PCs.
( I guess it is not able to load the data of qry1 on some PCs)
But when I put a dummy text field (Dummy:"Dummy") on qry1, qry2 works fine
on all PCs.
Weird!!!! Can anybody explain how can I solve the above problem.
(I am running on MS Access 97 on different PCs with Win XP.)
Thanks in advance.
SG

*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***

 

[SPG]

Hi All,
Any help???
Thanks.
SPG

Hi,
The problem is weird and the solution is illogical.
I would be grateful if somebody could please help me to sort out the
problem
in a logical way.
Thankyou.
SPG



*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from
http://www.SecureIX.com ***

 

[Douglas J Steele]

Have you applied all of the service packs to all of the machines?

Do all of the references point to the same versions of files? (See near the
beginning of http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
for what I'm talking about)