Number Format Changing in Query

[NSAMSA]

Hi all:

I have a calculated field in one of my tables that I am using in a query. For some reason, while the number has decimal places in the table, it is rounded in the query. I cannot figure out why this is occurring. Has anyone else experienced this, and how did you fix it?

Thank you

 

[Galaxiom]

Apply the CDbl function to the problem field in the query:

fieldname1: CDbl(fieldname)

 

[The_Doc_Man]

Call up the query in design view. Bring up the "properties" list. Select the column and see if there is a format or a number of decimal places. If the decimal places property for that field is blank, make it some number that you might wish it to be.

 

[NSAMSA]

For some reason, when I rounded to 3 decimal places in the original table, it brought back the decimals in the query. I can't say why this happened, but the query is somehow fixed. Hopefully I develop a better understanding.

Thank you for your suggestions.