Recent content by mtownbound

I figured it out, simple quotation error. Thanks for your assistance!!

Thanks. Created both and when I run it, the message box gives me " 1=1 AND ColorID In ('54') AND ModelID In ('13') which let's me know it's pulling the right items, but then I get a Data Type Mismatch error for the ApplyFilter Task.

Oops, lboShoes, not Model. Model is the actual column name in the table.

Apologies for the lack of clarity. The form frmShoeSelection has one list box, based on the [Model] field, that opens the report with selected shoe models. Now I need to add a second list box to the form, based on [Color]. The filter needs to be applied to the form frmShoeSelection and the...

So I have one multi-select list box that works fine, but I need to add a second field. I added the second string but my "And" statement wasn't working. Here's my original, so where do I need to add the code for the second field(the message box is just for testing): Private Sub...

I just added the subquery joined on ID and it worked. Thanks!!

Okay, I was good with the distinct query but now we have to add total items along with the distinct count in the same report so it looks like this: PK Item SalesID Dept City State Region 001 Bicycle 001 Sports Atlanta GA East 002 Helmet 001 Sports Atlanta GA East 003 Watch 002 Home...

Worked like a champ!! Thanks!!

Happy New Year!! Thanks for the feedback. You're right, my example wasn't too clear. I tried your method but it returns the total ID group count versus distinct count. For example, I got a total of 3 for Sports instead of the distinct total of 2 (based on SalesId).

Okay, I need to sum the distinct sales ID count at the dept, city, and state levels so here's my sample sales table: Item ID Dept City State Region Bicycle 001 Sports Atlanta GA East Helmet 001 Sports Atlanta GA East Watch 002 Home Atlanta GA East Shoes 003 Home Atlanta GA East Pants 003 Home...

Great,thanks again!

I'm adding weighting to my issue fields which will cause some of my txtIssueRates to be >100%(It's percentage format so it's really 1). For example, rather than having a 300% Issue Rate, I'd like to cap it so that anything over 100% only shows up as 100%. Currently, I'm using two fields to...

Worked great, thanks!

In is case it would be Mary Johnson with 250 and Brian Smith with 115.

Update on this thread, I also need to pull name of the person that had the max value in the group footer.