The created table from a query by “table to query” tool is different from the query,

[jamal numan]

The created table from a query by “table to query” tool is different from the query,



I couldn’t figure out how the created table from a query by “table to query” tool is different from the values of the query itself.

In the attached screenshots, the created table from a query is different from the query itself. For example, the value 11 in the query table (attached) has a value of 1 while it has a value of 1287 in the created table.

What might be the issue here? How come the created table from a query is different from the query itself?


Thank you

Best

Jamal

[June7]

That is odd - not happing in every record.

Is NumerOfFloors field a calculated field in Units_Buildings_Q3?

Why are you making table anyway?

If you want to provide db for analysis, follow instructions at bottom of my post.

[jamal numan]

That is odd - not happing in every record.

Is NumerOfFloors field a calculated field in Units_Buildings_Q3?

Why are you making table anyway?

If you want to provide db for analysis, follow instructions at bottom of my post.

Thank you very much June7 for the help.

You are right. The value of the “NumerOfFloors” are replaced by other values according to a combo box. At the moment all works five.

Best

Jamal