Access 2007 designing question

  cdbd 19:08 01 Apr 2008

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017