Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mtownbound

    Two Multi-Select List Boxes

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

    Two Multi-Select List Boxes

    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.
  3. mtownbound

    Two Multi-Select List Boxes

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

    Two Multi-Select List Boxes

    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...
  5. mtownbound

    Two Multi-Select List Boxes

    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...
  6. mtownbound

    Sum Distinct Count

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

    Sum Distinct Count

    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...
  8. mtownbound

    Sum Distinct Count

    Worked like a champ!! Thanks!!
  9. mtownbound

    Sum Distinct Count

    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).
  10. mtownbound

    Sum Distinct Count

    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...
  11. mtownbound

    Capping Field Value

    Great,thanks again!
  12. mtownbound

    Capping Field Value

    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...
  13. mtownbound

    Sum the Max

    Worked great, thanks!
  14. mtownbound

    Sum the Max

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

    Sum the Max

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

    Sum the Max

    Worked great, thanks!!
  17. mtownbound

    Sum the Max

    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...
  18. mtownbound

    Sum the Max

    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.
  19. mtownbound

    Sum the Max

    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...
  20. mtownbound

    Distinct Count in Second Group Footer

    Finally worked, thanks!

Part and Inventory Search

Back
Top