UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Best Field Types For Calculations, SQL Server 2012    
 
   
Everettc4
post Aug 7 2019, 06:57 PM
Post#1



Posts: 212
Joined: 12-June 06
From: Oregon


Hi all hey I am in the rapids with a SQL migration been learning a ton but.... now I have come to a query in access that calculates so reports can summarize. works great in access but linking to the exported SQL tables the query crashes. I'm pretty sure it's due to the field type SQL set when I exported. The question is what type of field is best for calculations when pulling into access? Also I'm not sure why SQL put brackets [] around some fields could that be causing problems??

Thanks for the help!

Attached File(s)
Attached File  SQL_FeildTypes.JPG ( 50.39K )Number of downloads: 8
 
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 07:14 PM