Search results for query: *

Hello--- Here is an example of what I am trying to do. I would like to find every unique "Number" that has a specific set of "Points." For instance, the unique Number values that have Points =5 And Points = 7 in this example would be: - 100019 - 334567 Row ID Number Points 1...

I have a query returning several records where Points=5. Table: old_table Query: old_query ID Number Points 1 876 5 2 345 5 3 989 5 4 112 5 5 394 5 6 834 5 I would like to search for the...

Hello--- Here is an example of what I am trying to do. I would like to find every unique combination of "Role" as it applies to "Number". For instance, the 3 unique combinations of "Role" in this example would be: -- ABC, DEF, GHI (this combination applies to 100019 & 558990) --...

Hello-- Please see my current code below. It currently runs the DoWhile loop for ID=1 until ID=250000. I would like to run the DoWhile loop starting at ID=250001 and ending at ID=500000. This needs to be done without altering the SQL. Any ideas? Public Sub fixData() Dim rs As...

Hello--- Here is an example of what I am trying to do. I am trying to select records based on the Number field. I would like to return Row IDs 4-7 when I search for Number = 800004. Row ID Number Name Points 1 100019 CCF RTE 155 2...

Hello -- I would like to create a new table by copying an existing table and also fill in some missing values in the new table. Here is an example: Original_table Row ID Number Name Points 1 100019 CCF RTE 155 2 242...