M
Matt
Is there a function in Access that works like the Sumproduct function in
Excel? I have a report that pulls from a query that has many fields. What I
want is for a field on the report to calculate the number of lines sold for a
certain person.
Let's say I have names of Jim, Jan, and Jimbo, and I have a product category
of A, B, & C with products A1, B1, C1, D1, E1, F1, G1, H1, I1, J1, K1, L1, &
M1 each product having a certain value for lines.
I want to calculate how many total lines Jimbo sold when the product
category equals A, and to count everything but E1 & J1.
Hopefully that made sense.
Excel? I have a report that pulls from a query that has many fields. What I
want is for a field on the report to calculate the number of lines sold for a
certain person.
Let's say I have names of Jim, Jan, and Jimbo, and I have a product category
of A, B, & C with products A1, B1, C1, D1, E1, F1, G1, H1, I1, J1, K1, L1, &
M1 each product having a certain value for lines.
I want to calculate how many total lines Jimbo sold when the product
category equals A, and to count everything but E1 & J1.
Hopefully that made sense.