I’m trying to create a query in Access that’ll give me a list of items with sales volume and sales share (market share).
To illustrate my challenge we can use a very simplified table that consists of PRODUCT and SALES VOLUME.
Example Table:
PRODUCT SALES VOLUME
Product A 40...
I'm exporting data from a query to a csv-file, and experience a problem with one of the fields. The field is a DOUBLE with FIXED FORMAT and TWO decimal places. The query returns a number of rows, but the problem only occurs for one of the rows:
When I look at the field in the query it shows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.