SQL Pass-Through Query...Access 2000

  • Thread starter Thread starter Lynn Pennington
  • Start date Start date
L

Lynn Pennington

Hi.
I have this statment in SQL...
SELECT SiteID, SiteName, City, State,
CAST(CONVERT(DECIMAL(9), Lattitude)/10000 AS DECIMAL
(10,4)) AS SiteLat,
CAST(CONVERT(DECIMAL(9), Longitude)/10000 AS DECIMAL
(10,4)) AS SiteLong
FROM roadnet_Site

When I run this in SQL I get the correct results.

When I run this via Access 2000 using a SQL Pass-Through
the results set has SiteLat and SiteLong as currency
format instead of a number format.

Any ideas?
Thanks,
Lynn.
 
If you display the results in a form or report, you can set the format to
whatever you want.
 
Back
Top