Search results for query: *

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.

...& "," & Me.Shoes.ItemData(varItem) Next varItem MsgBox (strSearch) If Len(strSearch) = 0 Then Task = "select * from qryShoesinInventory" Else strSearch = Right(strSearch, Len(strSearch) - 1) Task = "select * from qryShoesinInventory...

...strSearch = strSearch & "," & Me.Shoes.ItemData(varItem) Next varItem MsgBox (strSearch) If Len(strSearch) = 0 Then Task = "select * from qryShoesinInventory" Else strSearch = Right(strSearch, Len(strSearch) - 1) Task = "select * from qryShoesinInventory where ([Model] in (" &...

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!

...this, which is working, but checking to see if there's a more efficient way of doing it: [txtIssueRate] =IIf(([txtIssues]=0),0,(([txtLevel3]*10)+([txtLevel2]*5)+([txtLevel1]*1))/[txtIssues]) [txtCapRate] =IIf([txtIssueRate]=0,"0.00%",(IIf([txtIssueRate]>1,"100%",([txtIssueRate]*100 &...

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.

Worked great, thanks!!

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

Finally worked, thanks!