Search results for query: *

Hi PHV --- Thanks again for your help. However, I am having some trouble with your last post. I am looking to the following Numbers to be returned. - 100019 - 334567 - 558990 Am I missing something? SELECT A.Number FROM yourTable A INNER JOIN (SELECT DISTINCT Number FROM yourTable WHERE...

That is correct, there will not be repeated instances of 5 and/or 7 for a given Number. I have a follow up question though... It is possible to use PHV's approach to search for the following? Points=5 AND (Points=6 OR Points=7) -

Not yet...it is on my to-do list.

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

Yeah...you are right about the DB design issues. I'll have to investigate that further. In the meantime, the VBA code may be a quick alternative.

Thanks for the tip. However, I am only able to use the most basic SQL statements when working in my particular Access DB. When I use your code the DB hangs and doesn't finish processing. I believe it has something to do with the number of records (1.5 M). VBA code seems to work the best for...

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

Lots of good advice. A special thanks to TheAceMan1

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

I initially tried the straight SQL approach, but ran into performance issues. I am actually working with about 100 fields and 1 million records. I think MS Access was getting hung up due to the sheet volume of data being returned via SQL. Since the VBA approach is only handling one field, MS...

Lots of good help-- Hi MajP I am somewhat of a novice with VBA. I could use some help executing your code. A started by creating a class module. Is there a certain type of form object that I should be using? Thanks again!

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

Fantastic! It works great.

Thanks PHV. I am starting to understand. It seems a subquery will help solve the problem. However, I don't quite see how this creates a new table. Am I missing something? Thanks again

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