Linked to a SQL View with a SUM it is now TEXT

Hello everyone,

Using Access 2003 SQL Server 8.0

I have a link to a View on a Sql Server. The View does a sum of
inventory quantity -- sum(Quantity) as Qty --

When I link this view to my databalse Qty shows up as Text with a
length of 38. What's the deal. Can anyone help.

Thanks Ray

Re: Linked to a SQL View with a SUM it is now TEXT

Are you using an ADP or an mdb? I will assume an ADP.

what does the tSql for the view look like?

Here is a sample view I just slapped together to see if I have the same
problem

CREATE VIEW dbo.vxViewTbl
AS
SELECT rowID, fld1, fld2, fld1 + fld2 AS fld3
FROM dbo.xViewTbl

From an Access2003 ADP I can see fld3 as numeric which is the sum of
fld1 + fld2 which are both int data types. rowID is a primary key field
for the underlying table.

In order to see what the problem might be -- need to see the tsql that
creates the view

Rich

*** Sent via Developersdex http://www.developersdex.com ***