Search results

Thanks, Pat. Using DESC worked in getting the most common reason to the top of the list so it's displayed by default, but the list box is only one row in height (I'm trying to preserve screen real estate for the table data.). If I keep the entire list in there, it can only be navigated with the...

Thanks for taking the time to help. I have marked this as solved. Select Top N does exactly what I needed, and even preserves ties, which works well in my situation. I found I had to account for users filtering the form on the reason type field (done by a selection in a combo box, cboType). In...

Thank you for the reply. Using your suggestion, I was able to solve the problem by including VBA in the form's 'On Apply Filter' event that adds the form's filter to the listbox RowSource SQL: If Me.Filter <> "" Then strFilter = "AND " & Me.Filter Else strFilter = ""...

I have a continuous form, frmPoints, based on a query, qryPoints. The purpose of the form is to view, add, edit, or delete "points" given to students. The points can be either "Merits" or "Infractions" (the points are stored in tblPoints and the types in tblPointTypes). The form can be filtered...

Hello everyone. My name is Chris. I am from America. I've been using Access off and on for over 10 years and I'm just getting back into it after a long hiatus. I am an amateur but I get a lot of enjoyment (and occasional frustration) from building databases. Mostly I've used Access for my own...