• We are receiving reports of members using the private messaging service (Conversations) in ways that break/go against the forum rules:
    • Do not invite another member to take the question off the forum (i.e. do not suggest that they post to a different forum, do not suggest that they email or private message you the problem, do not simply post a link to another forum, unless it is to a specific, relevant, thread). This applies equally to members asking or answering questions.
    • Soliciting business for yourself is not permitted. This is an all volunteer board, so offering solutions in exchange for compensation is not permitted. Likewise, members seeking solutions must not offer compensation for them. If you have an urgent need, check the Consulting Services page.
    Please help us out by clicking the Report link on any messages you receive that violate these rules. Thank you
  • If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
    If you forgot your password, you can reset your password.

records

  1. L

    SUMIF matching 2 cells

    Good afternoon all, I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value ! I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3...
  2. V

    Difference in date

    I have this records below If the “PROJECT_NUMBER” is repeated AND “INCIDENT_CREATION_DATE” between the two incidents is less than 31 days then mark it as a "repeat" I am confused as how shall I do it, as did countif as well to find the duplicate and then the diff in date but the records can be...
  3. L

    COUNTIF / SUMPRODUCT with WEEKNUM

    Hello Guys. A quick and simple question (too difficult for me though). I have a column with dates (Column A). I need to count the number of records that are from the certain year (YEAR formula) and certain week (WEENNUM) without using any additional calculation columns (file is big, a lot of...
  4. T

    Delete only unused related records in another table

    I have used Excel for many years, but am new to Access! I am creating a database on which to log invoices received and track progress with authorisation, disputes, etc. through to eventual payment. As each invoice could have multiple progress updates relating to it, and each progress update...
  5. J

    Array question

    I have a array with 500 records and another array with 25 numbers. These 25 numbers are between 1-500. I want too clear all the records in 500 record array which are not in the 25 records array. Array1 10, 20, 31, 32, 45, 50 Array2 20, 45 After matching the result for array1 is 0, 20, 0, 0...
  6. M

    finding the size of a Data File BEFORE importing to determine how long it will take before import

    I been searching for a while to determine how many records in a data set. This is so I can determine how long it will take to import. I would like to use this information in a progress bar. I have the progress bar going, I just need to plug values in the code to have the bar move. I can make...
  7. D

    SQL Help - **Newbie**

    Hi ya'll - realizing this isn't an Excel question but hoping someone could help me interpret the output of the following SQL query and how it is structured. Here is some information about the database: - conversations_conversation records represent a single conversation between two people...
  8. Z

    how to update records through Forms

    Hello Everyone I'm Trying to Update my records through the form i created. not sure if its VBA or not! so any idea ?!:rofl:
  9. 2

    Exceptions table

    Hello, How can I return records from table-1 that do not match with records in table-2? I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records that I do not want to see in the resulting table. I need to do following: (Table-1) - (Table-2) =...
  10. C

    Bound vs. UnBound Forms

    So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive. The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as...
  11. B

    Filter Data from Drop Down List

    Hello All, This is what I need to do. I have a drop down list in sheet 1 that when a customer name is selected I want to copy in just the selected data for that customer name from another worksheet. I do not want to see all the records just the records associated for that customer. I've tried...
  12. S

    Excel form Vlookup result ...text box display blank.

    Hi, I am trying to pull out some records using vlookup and them in the corresponding text boxes. The vookup predefined function is working properly at it correctly displays the msgbox which says records not found in purchase records but when the matching record is found the textbox displays...
  13. T

    Approximate match / vlookup

    The problem I have involves looking for records within 2 tables. Table1, (the source), contains 100 records. Table2, (the sink), contains 1000 records. So to check if each record in Table1 is contained in Table2, looping would involve 100x1000=100,000 times (if I'm not mistaken). If instead I...
  14. D

    What's the fast way to do this?

    Whats the fastest way to remove all the symbols in a column of data in access? I only want the numbers and letters to be in my data. My database is about 4 million records and one of the fields in the records is a catalog number and I want to remove all the symbols in the catalog number in...
  15. D

    Hide Multiple number of rows based on a value

    Hey There - New to VBA & I need to workout how to hide a certain number of rows from a different worksheet based on the value inserted on another worksheet. Details are: * 'Summary' worksheet cell 'H10' the user inserts a value (e.g. 350), which is the # of records which will need to be...
  16. V

    VBA Code for Inserting Rows Based on Cell Value

    Hello all, I am trying to create a macro that will perform some very basic formatting. Essentially, I have a dynamic list of records that I want to display under relevant headers. I'm using a counta formula to determine how many records exist under each category. I then need the macro to insert...
  17. S

    Copying cells from one worksheet if their value matches cells in another worksheet

    Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...
  18. W

    Delete Query Not Working because table not specified

    Hello, I am trying to write a delete query to remove records from a table based on records in another table. There is a common field and I want to delete records in table 80 that have no matching records in table 01 (Below). The query works just fine but when I switch it to a Delete Query, it...
  19. S

    Merge Every 3 Rows into 1 row

    I have a data file of say 60,000 records and each record are up to column K. I need to combine every 3 rows as one row into a new worksheet. Input rows will be: A2 to K2, A3 to K3 and A4 to K4 Output will be on a new worksheet will be from: A2 to AG2 This formula will be for entire worksheet...
  20. T

    Copy data from a table into an empty table

    Hi, I have a problem that I need to delete the table records before I paste data into it. The problem is once I delete all the records, Excel VBA (BUG?) will not recognize it as a ListObject. Does anyone know a workaround? This code...

Some videos you may like

This Week's Hot Topics

Top