Re: Query Problem

From: Michel Walsh (vanderghast_at_VirusAreFunnierThanSpam)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 12:54:40 -0500

Hi,

    Does it SPECIFICALLY mentions the Format function? If not, you may have
a problem of reference, and the error then occur in the first external
function call, here Format. Check your project references.

Hoping it may help,
Vanderghast, Access MVP

"DCFujiwara" <douglas.fujiwara@utoronto.ca> wrote in message
news:ec49jMj1EHA.1404@TK2MSFTNGP11.phx.gbl...
>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.
>
>

Relevant Pages

  • Re: delete some users in an OU
    ... DSRAZOR for Windows has a service that you can include in an applet. ... can generate a query and then automatically delete the accounts based on ... the list can be a file in any format, .csv etc, how can i do this, ...
    (microsoft.public.windows.server.active_directory)
  • Re: format problem
    ... It's just an extra step to confuse Access. ... 2000 with windows XP as base. ... This query works fine in my pc and 2 other pc,but do not work on some ... pc's giving message.Cannot use the 'Format' thing,Not thw right way. ...
    (microsoft.public.access.queries)
  • format problem
    ... using in vba module.Our computers are connected on network on windows ... 2000 with windows XP as base. ... This query works fine in my pc and 2 other pc,but do not work on some ... pc's giving message.Cannot use the 'Format' thing,Not thw right way. ...
    (microsoft.public.access.queries)
  • Convert snippet of SQL to Access query.
    ... Using Access XP on Windows 2000 Pro..I am trying to create a query ... I cannot change any format, ... sql server would be the easiest way to go but it isn't possible.... ...
    (microsoft.public.access.queries)
  • Re: Reformat C when XP is already installed
    ... You can do a repair or reinstall.".. ... >> know that many try to format from the Command Prompt in Windows XP.. ... I don't know where this "there is no reboot in my ...
    (microsoft.public.windowsxp.hardware)