Problems with decimal places in a query

[shakey]

Hi
I am trying to build a Access data base which week by week will show a NAPS table leaderboard for my local pub competition
My brick wall has come on producing a query which will show just the member and a total sum of points accumulated
When i run the query the point total show whole numbers ie: for 0.9 points the result i 0 (zero) it wont even round up
Plese could someone point to my problem with a solution
cheers Shakey

 

[JHB]

Because you're using a calculate field type.

 

[shakey]

Ok but why doesnt it siply transfer one figure from the table into the query without changing it
calculations are "sums" if i add 2.2 to 4,1 i get 6.3 not just 6

do i have to change something in the field itself so that it works
shakey

 

[CJ_London]

try changing your points data type from decimal to double.

Decimals are a different datatype to the numeric datatypes. If you want to use them, then google how to use them - for a start you haven't specified a scale in your field properties.

This link should help to explain
https://en.wikipedia.org/wiki/Decimal_data_type

and this a bit more specifically

https://docs.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql

it relates to TSql, but the principle still applies to access sql

 

[shakey]

Solved: Problems with decimal places in a query

took some figuring out and searching for the right thing but it is SOLVED thanks very much
I can now progress
Goodwod isless than a month away :banghead:

 

[CJ_London]

for the benefit of others who are experiencing the same problem - please can you post your solution