DSUM
I have a table with 4 columns.
DATE, MOLD, SOURCE, PARTS
(DATE IS A DATE, MOLD AND SOURCE ARE TEXT, AND PARTS IS NUMERIC)
I have a second table that contains.
DATE, MOLD, SOURCE2, GROSS
(DATE IS A DATE, MOLD AND SOURCE2 ARE TEXT, AND GROSS IS NUMERIC)
What I want is a function that I can place in the 5 colum of the second
table that would sum all the values in the parts column of the first table
were the DATE and MOLD match the DATE and MOLD on the corrisponding row of
the second table.
I thought I could get there with DSUM but I am having no luck.
|