The data type of your QTY field is set to Number in the table but its field size probably set to Single, Double, or Decimal. Change that to Byte, Integer, or Long. Byte is fine if you don't expect your quantities to go above 255. Integer is okay up to 32,767. Long is much greater still.

I tried replicating your problem with a table that had the data you gave and exporting a query from that table but I was unable to get the same result. If you could upload a stripped down version your database that exhibits this problem, then that could help.

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.

With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…