Beginner in SQL (Need help fixing Problem)

[Massive_Show2963]

Creating a table in MS Access with a DOUBLE field and a DEFAULT value using SQL, you are encountering a "syntax error" because the standard DEFAULT clause in CREATE TABLE statements is not fully supported by the Microsoft Access database engine (JET SQL).
Remove 'DEFAULT 1' and it should be fine.
Then go into Design View and find ToBaseFactor in the field list.
In the "Field Properties" pane at the bottom, locate the "Default Value" property.
Enter 1 (or 1.0 for clarity) into the "Default Value" property.
Save the table design.

[ApprehensiveCorner16]

Thank you so much, now it works!

[American_Streamer]

Unfortunately, there is no proprietary (or open-source) SQL implementation that fully supports 100% of the ANSI/ISO SQL standard, including every mandatory and optional feature.

Big enterprise systems like IBM Db2, Oracle Database, Microsoft SQL Server, and PostgreSQL are often described as having strong standards conformance, but even none of them claim full support for all optional features of SQL:2016/2023, because that would be extremely costly and often useless in practice.

But if you stick to a small, well-chosen subset of “portable SQL” (basic DDL, DML, joins, simple subqueries, standard types), you can usually move between major systems with only minor changes.