Linked table with percentages

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.
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"
<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.
|||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 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"
> <SharonInGa@.discussions.microsoft.com> wrote:
>
>