Problem with queries showing too many records

[connerlowen]

HI,

I have a database that is used to create Quotations. After all of the information is entered the queries that hold the calculations must be run. I have lots of calculated that rely on other calculated fields. When I need to Sum all of the calculated fields in one field I must create a new query. I currently have a QuotationID, PartID, and MetalID all linked together. The first of the calculations are done per Metal, and these are working fine. I run into a problem when the calculations need to be done by part. My Queries are creating a record for every Metal and this is throwing all of my numbers off. Any suggestions would be greatly appreciated.

Thanks,

Conner Owen

 

[jdraw]

If you are getting more records than expected, it is probably because of your criteria. Check your query sql -- suggest you post the query SQL.