Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / November 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
eighthman11 - 06 Nov 2007 17:14 GMT
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
Rich P - 06 Nov 2007 18:26 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.