Totaling two tables

[Mike Cook]

I have a db that has 2 tables, one for material sold, one for material produced or purchased. I want to be able to have an inventory add to it any purchases or productions and deduct any materials sold. Each of the two databases have about 140 rows each in the table so I cannot combine the tables into one. I have done this using a test database and it worked with 2 fields in each table, but when I do the same thing with the larger db's form wizzard says it cannot create the form.

 

[KDg]

Have you tried 3 queries?

1/ counting "material produced or purchased"
2/ counting "materials sold"

and then 3/ doing the maths you need

if you base your form on 3 it should work, otherwise you're off into VBA and unbound boxes

HTH

Drew


- apologies for the undbound boxes, forgot I was in reports.

[This message has been edited by KDg (edited 02-24-2000).]