SQL Pass-Through Query...Access 2000

[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.

 

[Duane Hookom]

If you display the results in a form or report, you can set the format to
whatever you want.