Formatting calculated fields in a Query

[pnpez]

I have 2 queries that create 2 separate tables, A and B. The 2nd query is dependent on the answers from table A, made from the 1st query.

I put a calculation in X-field in the 1st query, but the resulting answer in table B formats this X-field as text, no matter what I try.

I'm not great at formatting in queries so any suggestions would be helpful.

Thanks

 

[jdraw]

Post the sql of the query.

 

[spikepl]

Wrap the result in the desired type-conversion function, Cint, Cdbl , Cwhatever, to cast the result into desired data type.

 

[pnpez]

Sorry, but I don't have SQL programming knowledge.