D
DCFujiwara
I run the following query in an Access 2003 database (MDB) running under
Windows 2000:
SELECT S.ScheduleID, Format(S.GameDate,"dd-mmm-yyyy") & ": " & [V.TeamName]
& " vs " & [H.TeamName]
AS ScedEntry, S.WeekID, S.GameDate, V.TeamName
FROM
Teams AS V INNER JOIN (Teams AS H INNER JOIN Schedule AS S ON H.TeamID =
S.HomeID)
ON V.TeamID = S.VisitingID
WHERE
(((S.VisitingID)=[V].[TeamID]) AND ((S.HomeID)=[H].[TeamID]))
ORDER BY
S.WeekID, S.GameDate, V.TeamName;
If I copy the MDB file to a PC running Access 2003 under Windows XP SP2.
this query produces and error message indicating that the FORMAT function
cannot be used in the query, yet it runs OK running under Windows 2000.
Help would be appreciated.
Windows 2000:
SELECT S.ScheduleID, Format(S.GameDate,"dd-mmm-yyyy") & ": " & [V.TeamName]
& " vs " & [H.TeamName]
AS ScedEntry, S.WeekID, S.GameDate, V.TeamName
FROM
Teams AS V INNER JOIN (Teams AS H INNER JOIN Schedule AS S ON H.TeamID =
S.HomeID)
ON V.TeamID = S.VisitingID
WHERE
(((S.VisitingID)=[V].[TeamID]) AND ((S.HomeID)=[H].[TeamID]))
ORDER BY
S.WeekID, S.GameDate, V.TeamName;
If I copy the MDB file to a PC running Access 2003 under Windows XP SP2.
this query produces and error message indicating that the FORMAT function
cannot be used in the query, yet it runs OK running under Windows 2000.
Help would be appreciated.