Search results

  1. B

    Finding the 10 most common entries in a given column

    Hi all, I am struggling a bit to come up with a solution here. I would like to have a column that just lists the top 10 most frequent text entries from another column. Ideally I would like to do this as a formula as macros are not supported on the online excel version. I have tried the...
  2. B

    Solved Excel Formula to find if there is a match in the left two characters of cell and if so paste value below the match

    Hi All, I am struggling with finding the best way to set up this formula in Excel. Essentially what I want to do is to check the left 2 characters in cell B28 of my worksheet titled "Data" and see if there are any matches with values in range B1:AH1 of my worksheet titled "Calculations", and...
  3. B

    For every "Y" value in column check value on left and reference to other worksheet and paste values

    Hi All! I am struggling to build functional code to essentially check range B2:B34 in worksheet "Driver" for any "Y" value and then check the left value, for example "1a" then check if any headers match in the "Calculations" worksheet and paste the four values below that header to a worksheet...
  4. B

    VBA Module that Hides headers that are not needed

    Hi All! I will preface this by saying that I am fairly new to using VBA in excel. Essentially, my goal is to have a user input what "indicators" they would like to see data for, and then hide the other data that they do not specify they would like to see. I don't even know how I would go about...
  5. B

    Search for value and then count the values in the same row as the value

    Hi All! I have tried so many things at this point I think my brain is entirely fried. I am trying to find out how to check if a value matches a stated value in a formula and then counts the values in the same row it was found. This will be made more clear by looking at the attached image...
  6. B

    Solved Handling Null Values from a Listbox in a Query

    Hi All, So I am unsure how I should start this question off, but I am having trouble with handling null values from a listbox. I want the query to check what value is stored in the lsitbox and then only show results for that value. In the past I have used a "janky" method as seen here: Like "*"...
  7. B

    Solved Query which pulls Values from a forms Textboxes and Displays data between the two Values in those Textboxes

    Hi All! I am struggling to find a way to do this. Essentially I want a query to figure out what is in two textboxes on a form and display only the data that occurs between those two values. In this case between two years as seen in the attached image below. Likely something using the Between...
  8. B

    Solved Pulling Data from a Query Field to be Displayed in a Textbox

    Hi All! I am wanting to pull the value from a field in a query to be displayed in a textbox. As seen in the image attached I tried referencing it as follows "[qry_SPL3]![fld_IDIT]" but this just gives me the "#Name?" error also as seen in attached. Below is what the Query I am trying to pull...
  9. B

    Solved Extracting ONLY Numbers from a Field to be used for Sorting

    Hi All! I am just wondering if there is a method of only pulling numbers from a field in an Access query. Basically, I want to be able to use a field with just the numbers as a means of sorting and filtering later on in this database but I can't use Left() or Right() (to my knowledge anyway) as...
  10. B

    Solved Count Unique Values in a Query

    Hi All, I am trying to count only the unique values in a specific column in my query. The field I am trying to count unique values for is the field "fld_CrNo". I have tried using SELECT DISTINCT but to no avail. There may be something more complex I need to implement in order to get it working...
  11. B

    Query to sort by season + year

    Hi All. I am building a database that houses my grades with the intention of displaying my average grade per semester. The problem is that my field "fld_Smst". The data stored in this field goes by season first, then year, so "Fall 2018" or "Winter 2019" for example. What I would like to do is...
  12. B

    Solved Problem limiting to unique records in Query

    Hi all! I have two queries, one detailing the sum of revenue over three years and the other detailing the sum of expenses over three years. I want to have a query that shows the two sums beside each other along with the years. The two queries both only have three entries, but when I combine the...
  13. B

    Solved Is there any way to make a field specifically for entering data (similar to a table) in a query?

    I want to add a field called "Grouping Description" to a query that will detail the meaning of something called a grouping code (basically tags). The reason I want to do this in the query is because it contains only the distinct grouping codes so adding the description there would be much easier...
  14. B

    Problem with query filtering for line graph

    Hi everyone! I am currently in the process of making a graph that can be filtered based on values in a combo box. I build a query specifically for the graph that contains the year, the grouping codes associated with items (basically tags), and the total amount spent per grouping. Usually using...
  15. B

    Solved Graph that shows amount spent per item grouping each year

    Hi all! I'm having trouble finding a solid way to create a scatter graph from a query that would show the yearly amount spent on each grouping of items (for example amount spent on wood, computers etc.). I've been using mm/dd/yyyy format for the dates in the table the query is pulling from and I...
  16. B

    Solved Adding Total to Page Footer in Report

    Hi all! I am using a textbox to try and output the total cost of the items in my report I generate but I simply get the text "#Error" when testing. In the "Control Source" section of my text box ("txt_Tot") I am using to display the total, I have "=Sum([Amount])" but this does not seem to work...
  17. B

    Solved Search Year of Delivery Date via Combo box on a form

    Hi all! I have a field in a query in which the day, month, year and time of delivery for an item is stored (mm/dd/yyyy format). I know how to limit to the delivery date in mm/dd/yyyy format but is there a way that I could limit it to simply year. I tried just typing "2020" for example, in the...
  18. B

    Solved Removing time stamp from "Date/Time" Fields

    Hi All! I'm having trouble removing the time on a date/time field in a table. I want to use "mm/dd/yyyy" format but every time I try to make use of the format it adds a time to the field as well. I have tried looking around for solutions (perhaps I'm not looking hard enough) but its getting...
  19. B

    Using a button and combo boxes to filter to specific records for editing

    Hi All! I am currently working on a database that houses requisition and inventory data. I want the user to be able to fill in any number of combo boxes with information and click a button to filter to whatever was typed in one or all of the combo boxes. The purpose of this is to be able to...
  20. B

    Solved Hide 'Previous Record' Button when on First Record

    Hi Everyone! I have tried everything I can find online and I cannot seem to figure out how to hide my previous record button when a user is on the first record. I've tried using the "RecordSet.AbsolutePosition" method but I can't seem to get it to work. Any help would be fantastic! Thanks!
Top Bottom