Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jokkis

    Query giving sales volume and sales SHARE

    BIG THANKS Golom! That solved my problem. Must admit that my SQL knowledge is rather rusty... Many thanks to you all for your valuable help!
  2. Jokkis

    Query giving sales volume and sales SHARE

    Many thanks for your input. A problem now is that Access constantly gives me an error message when I try to use data from another query (as you suggested lespaul) and the same if I follow your suggestion Randy: "You tried to execute a query that does not include the specified expression...
  3. Jokkis

    Query giving sales volume and sales SHARE

    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...
  4. Jokkis

    Problem when exporting

    Hi PHV Big thanks for your input. No, I haven't tried that function. But how do you apply such a function for a specific field in a query result during an export procedure?
  5. Jokkis

    Problem when exporting

    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...

Part and Inventory Search

Back
Top