Sorry if this is redundant. I tried to find an appropriate thread.
I have 2 tables. one is a projects table. one is a bill of material(BOM) table. for any given project there will be several records in the BOM table. I would like to add the total dollars for each project but only show one line for each project. I know how to sum but I keep getting an output line for each project times the number of matching lines in the BOM. Any help would be great!!