Access 2007 designing question

  cdbd 19:08 01 Apr 08

Please help? I am trying to build a database for our small company. I want to see all records of my Purchase Qty, Sales Qty, Invoice Sales Qty together. When I try and make a query that does this as I add the different Qty queries the records deminish. I have about 300 products, and 200 Items I have purchased this year, and about 150 of the items have sold (in dif quantities). So my end result is that only 150 Products show instead of 300. And when I add my Order query which have about 24 products that have sold in different quantities, only 24 products show. I would be greatful if I could send a more experienced person my database and I could also explain more. Many thanks, Craig.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 7 simple tips to get more out of…