This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am having a problem with an append query that seems to be rounding my #'s???
When I run the query in datasheet view, it looks fine with actual dollars (my formatting is set to standard with 2 decimal places). But, when I change it to an append query to add to a table I have set up it seems to be rounding the dollars on me. My formatting in the table is also set to standard with 2 decimal places & I'm not sure how else to correct it.
I've attempted to recreate the query and the table thinking it might be something that was embedded in the formatting, but that didn't seem to work either - help!!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Formatting is just for display. What is the actual DataType in the table where the data is going to? Access defaults number field to be Long Integer which has no decimal places even if you make it display them.
Change datatype to currency.