Synax for decimals

[Guest]

I'm trying to design a query where I take a number in a number field (from a
table) that is a decimal number and I extract the portion of the number that
is not a whole number and append it to another table (example, the number is
2.75 and I want to run a query that will take the .75 and append it to
another table.)

 

[Geof Wyght]

Dennis,
Try something like:
SELECT Scores-Int(Scores) AS Remainder
FROM Scores;