SQL Bigint convert to Access

B

BigHair101

I have fields in SQL that are "bigint" and when linked in Access they change
to text. I need them to stay numeric so that I can total them.

What do I do?

Thanks for any replies.
 
T

tedmi

Instead of linking to tables in SQL Server, link to a query which converts
BigInt to Double and returns the other columns unchanged. Problem is that
BigInt has precision to 19 decimal digits with no rounding errors, while
Double has 15, so you won't EXACTLY the same results in Access as you would
by summing in SQL Server.
You may get more accurate result if youlink to a query which does the
summing on the server, then returns the result converted to Double.
 
Top