J
Jay
I am attempting to do a grouping on a data set which looks like the sample
below. The field name is: "AcctDept_Prod_Cat" and the data looks pretty much
as the sample below does.
SFSV Profile Substrate
342A - SFSV Airwear
PAL Ovation Airwear
The solution to this one is fairly simple: Left([AcctDept_Prod_Cat], 4) =
"PAL " OR
InStr([AcctDept_Prod_Cat], " PAL ") > 0.
This isolates the items by product, which is great. However, now, I am
needing to pull all correct data values, if there are any, for the subsequent
data points. I have a quick and dirty type of crosstab query which is used to
sum values which looks as follows WG:
Sum(IIf([strFriendlyName]="WG",[SumOfnumRejectedQty])). Now the
"StrFriendlyName" field contains the name "WG" and the "SumOfnumRejectedQty"
contains the numeric value for that item.
What I now need is a method, possibly using one pass to sum and group all
records "SumOfnumRejectedQty " to one record value connected to the "PAL" or
"SFSV" grouping for the "WG" item column.
Is this possible?
I hope that I was clear in my explanation. if further information is needed
feel free to post a request for such.
Thanks,
below. The field name is: "AcctDept_Prod_Cat" and the data looks pretty much
as the sample below does.
SFSV Profile Substrate
342A - SFSV Airwear
PAL Ovation Airwear
The solution to this one is fairly simple: Left([AcctDept_Prod_Cat], 4) =
"PAL " OR
InStr([AcctDept_Prod_Cat], " PAL ") > 0.
This isolates the items by product, which is great. However, now, I am
needing to pull all correct data values, if there are any, for the subsequent
data points. I have a quick and dirty type of crosstab query which is used to
sum values which looks as follows WG:
Sum(IIf([strFriendlyName]="WG",[SumOfnumRejectedQty])). Now the
"StrFriendlyName" field contains the name "WG" and the "SumOfnumRejectedQty"
contains the numeric value for that item.
What I now need is a method, possibly using one pass to sum and group all
records "SumOfnumRejectedQty " to one record value connected to the "PAL" or
"SFSV" grouping for the "WG" item column.
Is this possible?
I hope that I was clear in my explanation. if further information is needed
feel free to post a request for such.
Thanks,