We create many calculated fields in queries like everybody. I wondered why, when these calculated fields then return a type "Short Text" I don't understand why. The fields they derive their numbers from, is number fields from a table, why does Database Documenter then say Short Text. We pick up issues then in Union Queries "Data Type mismatch in criteria expression".