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    
post Aug 7 2019, 06:57 PM

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    9th July 2020 - 03:20 AM