How to use thousands separator for a base query calculated field?

hello i’m new for base
and sorry my english is bad
how to use thousnds separator?
like 10000->10,000.00
i trying serch and find add .00,
but thousand separator 3 soluation not work
maybe that function not support Hyper SQL
i set 2 table “cost” “req” format #,##0 and Field Type is NUMERIC
libreoffice version is 7.3.5.2
and use embedded HSQL DB

QUERY SQL

Hello,
Please see this post → Base: Format numbers in queries - #2 by w_whalley

1 Like

i see
thx for help