No query result when running an Access 2000 dbase in Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey Folks,

I have a gremlin which is really bloody frustrating. I have written a query
in my database (I am using Access 2000) that opens, but with no records, when
a user running Access 2002 opens it. It works fine for me??

I had an Access 2002 user rewrite the query, but it still doesn't open for
them (fine for me).

Has anybody come across this? Words of wisdom would be appreciated.

Thanks,

Paul
 
SQL is as follows:

SELECT T_Sites.[Branch Name], T_Sites.SiteBSB, T_Sites.[CommSee PoP Id],
T_Sites.PoPSiteComments, T_Sites.[No of workstations/Laptops] AS [No of Ports
Required], T_Sites.[Ports Assigned], T_Sites.EthPortsPatched AS [Ethernet
Ports Patched], T_Sites.TokenRingPortsRemoved AS [Token Ring Ports Removed],
T_IPAddressing.CommseeServName AS Server, T_IPAddressing.CommSeeSwitchPort AS
[Prim Port], T_IPAddressing.CommseeSwitchILO AS [Prim ILO],
T_SiteVisits.Visit, T_SiteVisits.Date, T_SiteVisits.Arrive,
T_SiteVisits.[Start Patch], T_SiteVisits.[Finish Patch],
T_SiteVisits.Signoff, T_SiteVisits.Comments
FROM (T_RouterID INNER JOIN T_Sites ON T_RouterID.[Router ID] =
T_Sites.[Router ID]) LEFT JOIN (T_IPAddressing LEFT JOIN T_SiteVisits ON
T_IPAddressing.[Project Point of Presence Id] = T_SiteVisits.[POP ID]) ON
T_Sites.[CommSee PoP Id] = T_IPAddressing.[Project Point of Presence Id]
WHERE (((T_SiteVisits.Visit)="3 Comm Cutover" Or (T_SiteVisits.Visit)="5
Call Back") AND ((T_Sites.CoreActivity)="c" Or (T_Sites.CoreActivity)="h" Or
(T_Sites.CoreActivity)="b" Or (T_Sites.CoreActivity)="m") AND
((T_Sites.PoPCutover) Between [forms]![F_GeneralReporting].[txtStart] And
[forms]![F_GeneralReporting].[txtend]))
ORDER BY T_Sites.[Branch Name];
 
Back
Top