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.
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...
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...
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...
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...
Getting there, it's pulling the correct max value but it's now adding the max value to each row so it's essentially:
IT Dept Tickets MaxDept
Thomas Smith 200 250
Mary Johnson 250 250
Ken Allen 150 250...
Thanks for the response. The max function is working for the group footers with no problem, but I need a sum of those group footer max values in the report footer.
Just want to sum the max values (max([Tickets])) of all groups:
IT Dept Tickets
Thomas Smith 200
Mary Johnson 250
Ken Allen 150
IT Footer Ticket Max: 250
Finance Dept Tickets
Brian Smith 115
Mark Lind 37
Linda...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.