Groups | Blog | Home
all groups > sql server odbc > december 2004 >

sql server odbc : Linked table with percentages



SharonInGa
12/1/2004 6:41:09 AM
I'm using Access as a front end to a SQL table. What format do I need to
SharonInGa
12/1/2004 8:05:02 AM
I'm in access2003. The fields in the SQL table are defined as Numeric 9
(10.4). Those same fields are appearing as Currency in Access although the
table is directly linked to SQL. I'll also post this in the Access
Newsgroup. Thanks.



[quoted text, click to view]
Mary Chipman
12/1/2004 10:38:53 AM
What version of Access? ADP? MDB? It involves setting the Format
property in the Datasheet, Form or Report. If you have any further
problems with this issue, you'll get a wider range of responses
posting in one of the Access newsgroups since it's really an Access
issue that has nothing to do with SQL Server.

--Mary

On Wed, 1 Dec 2004 06:41:09 -0800, "SharonInGa"
[quoted text, click to view]
AddThis Social Bookmark Button