Field Type

[Perfac]

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".

[ranman256]

In query design, bring the field down,
select the field column,properties,
set format.
or
use a conversion function:
CDbl(field)
cLng(field)

[orange]

Please provide a few examples to help put your post into context.

[isladogs]

The output datatype will depend on the calculation.
If for example you add two numbers, the output is a number
However if for example you apply some types of formatting, you could end up with a string.
This can be easily shown with date fields. If you format as e.g mm/dd/yyyy you are creating a text string.

As already stated, if necessary you can use conversion functions CInt, CLng, CDbl etc to ensure the calculated value has the required format

[Perfac]

I selected the properties, many times it does not put available any selection. You may see that I typed in "Currency". Still Database documenter returns "Short Text". Ranman, sorry for not getting it fast. What do you mean "Use a conversion function"? CDbl........

[Perfac]

Ridders. How do I use functions CInt, Clng, Cdbi. I will search for a tutorial. Thanks.

[orange]

Perfac,

Don't overlook the use of Google or Bing to find info/articles on Access functions etc.

See this link for Access functions and sample of their usage.
Also, what is the purpose of numeric suffixes on most of your fields?

[isladogs]

Just wrap your expression with the conversion function
e.g. CLng(expression), CInt(3.25),
for currency, use CCur

[Perfac]

Thanks. Just overworked and brain dead today.