Re: Linked table with percentages

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SharonInGa (SharonInGa_at_discussions.microsoft.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 08:05:02 -0800

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.

"Mary Chipman" wrote:

> What version of Access? ADP? MDB? It involves setting the Format
> property in the Data***, 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"
> <SharonInGa@discussions.microsoft.com> wrote:
>
> >I'm using Access as a front end to a SQL table. What format do I need to
> >put the SQL fields in to appear as percentages in Access.
>
>

Quantcast