Hello,
I am writing a report based on a query where I need to sum the quantity of a part based on a criteria (type of transaction). The DSum expression requires that I look at the query used, instead of the detail of the record in the report and my answer returned on the report is totaling all records in the query based on the criteria, not the individual record (part number).
I have tried the follow, but keep getting errors:
=DSum("[Quantity]","TEST1QRY", "[TEST1QRY]![Part Number] = [Inventory Transactions].Report![Part Number_Inventory]", And "[Transaction Type]![ID] = 1")
Please help!
Heidi
I am writing a report based on a query where I need to sum the quantity of a part based on a criteria (type of transaction). The DSum expression requires that I look at the query used, instead of the detail of the record in the report and my answer returned on the report is totaling all records in the query based on the criteria, not the individual record (part number).
I have tried the follow, but keep getting errors:
=DSum("[Quantity]","TEST1QRY", "[TEST1QRY]![Part Number] = [Inventory Transactions].Report![Part Number_Inventory]", And "[Transaction Type]![ID] = 1")
Please help!
Heidi