Summing a Query

I have a query that calculates the total cost of goods of each product
(COGS = Price * Inventory).

I then use another query to group each brand (each brand has 10
different products) together and sum the total cost of goods for the
brand. Why am I getting a value that seems like a multiple of the sum
of inventory?

Any help in this is greatly appreciated!!

.

Relevant Pages

  • unexpected query result
    ... I created a database file for sales and inventory management. ... I have goods A, B, C, D, E in the item info table ... I imported A, B, C, D in certain quantity, created a query for stock-in ...
    (microsoft.public.access.queries)
  • Re: Need Help designing a table structure
    ... Well, I don't really know anything about ColdFusion, but you could do what ... form with fields that represent the fields from the inventory table, ... The form which is unbound can call another form ... which is bound using that query as the record source. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Live Inventory Database
    ... Initially I want the "Inventory" table to ... reflect the "Goods In" table. ... I'm going to presume you have a relationship from Inventory to Goods In and to Invoiced Items based on Item number. ... You can put all these scripts in one, just use Script Parameters to distinguish which one runs. ...
    (comp.databases.filemaker)
  • Re: Show all records on a joined query with criteria
    ... > inventory items to the order. ... " created one query that has 2 tables joined showing ... SQL View from the menus, View> SQL View, and copy and past the SQL ... MyTableOneID AUTOINCREMENT PK ...
    (microsoft.public.access.queries)
  • Re: parts inventory management
    ... You might also want to look over the MS template for inventory management. ... PurchaseOrderNum ... TblPurchaseOrderDetail ... The query would include ...
    (microsoft.public.access.tablesdbdesign)