Combining Queries from tables?

[smaigs]

I have created a database which is for materials used on a contract. I have a table incorporating material codes. I have had to create multiple tables for each type of work to enable various calculations to be made ie sum of materials used on each type of work.

The problem then occurs when I try to combine these multiple queries(calculations) to result in one table of material codes for a scheme. The result seems to combine all materials of each code and totals each one for each type of work. Instead of a total of 4 for 4 types of work i might get a total of 12, 17, or 24 etc. The total query seems to add each item from each type of work numerous times.

Hope this is clear and I hope someone can help

Thanking you in anticipation

Smaigs

 

[bat17]

It sounds as if you have not joined the tables correctly and are getting a Cartesian product. One thing that can cause this is if you have multiple field indexes but have only joined one of the fields in the query.

From the description you give of your queries, you probably want to join them back into one using a Union Query.

HTH

Peter

 

[smaigs]

Thanks Peter I got it to work by creating the union query. It works great

Smaigs