Search results for query: *

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

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

The running sum is working great at the employee level and is totaling correctly in that group footer, but I need to sum the distinct employee sales transactions in the department footer, as well. Here's what I have: Name: txtEmployees Control Source: =1 Running Sum: Over Group Visible: No...

I need to create a field that serializes and increments based on the value from a combo box, doesn't have to be the PK, just need a "ID" text box. Something like this that's updated when the user selects the value in the Combo: Type ID Phone PH00034 Phone PH00035 Email EM00017 Phone...

Trying to get a distinct count total in the footer of each of my Category groups. I know about: Name: txtCategory Control Source: =1 Running Sum: Over All Visible: No Name: txtTotalCategories Control Source: =txtCategory Running Sum: No Visible: Yes However, I need to capture the count for...

This is what I have: Order Number Order Date Item State 99801 1/5/2015 Shoes FL 99801 1/5/2015 Pants FL 99802 3/7/2015 Shoes TN 99803 4/7/2015 Shoes UT 99803 4/7/2015 Shirt UT...

So trying to conditionally suppress group footers with the following, in the On Format event, but it's still showing all footers: GroupFooter0.Visible = (txtBrand = "Nike") Thanks

I have a form that is used to enter data, but I need to have a field, that populates a child "Comments" table that I can use to capture user comments and later view all the comments for a given record.

I need to split certain categories into multiple rows. Currently, I have the categories grouped in my report as: 1) Reebok 2) Nike 3) Addidas However, what I need is: 1) Reebok 2) Air Jordan #Formerly grouped in Nike Category 3) Nike Airs #Formerly grouped in Nike Category 4) Adidas...

I have record ID's for each help desk entry. I have different departments that are reponsible for different areas based on category. I need to group the entries by departments, with one field displaying all the record numbers for each respective department in either the group or report footer...

I have a table for shoes and a table for sales. I need to report the number of shoes sold and even the ones that didn't sell. For example: Brand Sales Net Nike 540 $32,934.00 Adidas 0 $0.00 Reebok 23 $11,432.00 Thanks

Need to create a simple subtotal field in a report using the expression builder similar to: Sum([Field A] and [Field B]) where [City] = "Tallahassee" Any ideas, Thanks!!

If I use regular text boxes and type any of the values, the query works properly. If I use combo boxes and select the values from the dropdowns, the query doesn't return any values. Here are the criteria I'm using for both the text fields and the combo boxes: Like "*" &...

I'm trying to order by week, but I want to group and display only the month in the chart. Much easier to understand in the attached pics. http://www.mediafire.com/conv/d66a8ed08800b840772aff7854b0e308fed05cfd1f3d6e2c3c4421ef29eae8a86g.jpg...

How can I shift the lastfullweek from Sunday-Saturday to Wednesday-Tuesday?

Started this in another post but figured it'd be best to start a new thread....I need to take all the group names and the running totals for each group and put them in a formatted formula field in the report footer. Any ideas? Thanks!!

I'm charting players' points with a bar chart in my report, but players that have zero points are being also displayed in the chart. I could add amplifying information, but it's a pretty straightforwrd issue(or so it seems) [2thumbsup] Thanks!

To improve efficiency, I'm trying to chart the percentage of shoes that required restitching per technician. Would like to ideally display it in a stacked bar chart with the percentages instead of the values. Tech Shoes Made Shoes Requiring Rework Rework Percentage Lois 245...