Amend Query round numbers when Run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm running an ammend query and when I view the data before running I have
numbers like 1.45 and 1.95. After the query is run and I look in the amended
table, the new lines show 1 and 2 respectively.

Then initial query which creates the table does so with the full decimal
values.

Any help on getting the amend query to do the same would be greatly
appreciated.
 
the fields you append to, in the second table, might be integer or long format.
Try to change them to double.
create the field on the table that you append to, to be similar to the
fields you append from.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Access Default Microsoft Access Order Entry database issue 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Unique values in two fields in query 1
Retrieving boolean value from popup box of an amend query 1
Access #Error & Excel Pivot 0
Changing a number field to Autonumber 5
Eliminate duplicate values in a query 2

Back
Top