Diff Query Results on different PCs

  • Thread starter Thread starter SPG
  • Start date Start date
S

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 ***
 
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
Click to expand...


*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***
 
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 ***
Click to expand...
 
Back
Top