querry or report

[kamnjoro]

I trying to create a database tgat will perform some inventory control... i am stranded in creating a querry that will output the goofs in stock based on a sales table and a purchases table
please help

[June7]

To answer the question implied in title - use report based on query.

This will probably require several queries and all depends on your data structure.

Do an aggregate query that sums stock purchases grouped by product ID.

Do an aggregate query that sums stock sales grouped by product ID.

Do a query that joins the two aggregate queries to master products table.

Use the third query as report RecordSource.