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