Skip to content
Advertisement

Unable to get division to work on joined subqueries

I am amalgamating queries I run in MS Access to run on SQL Server and whilst results display OK, I can’t get the division to work (it displays 0)

The total seem to calculate OK but as soon as I add Completed.[Completed Account] it results in nil.

Any help would be appreciated.

Here’s my query:

Advertisement

Answer

try the following, multiply by 1.0

second option is to cast to decimal

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement