Search results

I am using the following statement: INSERT INTO table1 SELECT * FROM query2 WHERE 'table1.ID'<>'query2.ID' There is already data in table1. I want to it to insert data to the table only where there already is not data listed using that ID The macro runs but it just inserts everything from...

OK I figured it out. When I went to pull samples of the data to put in a db to share here I found the data I needed was missing from one data set. This would explain why it was showing up in one query and not the other. It turned out my boss had updated a field in the table to equal "" where...

I edited my OP to add that both queries are joined on the EXACT same fields. If it was something as simple as there was a space (which I already thought of and checked) then the data would not match up in both queries.

I have two data sets - a master table and an application table. Both tables have multiple fields that differ but have six fields that are supposed to match each exactly. I wrote two queries: master vs application tables -> checks to see if there is anything in the master that is not in the...

To me the funny thing is that if you run that IF block with the MsgBox and you do not tell it to stop it will go on and do other things after the block. When it hits the submacro it just stops.

I thought it was fixed. If delete the MDL_MAST_2 table from the query it will run. I fixed it and replaced the zip folder.

I figured it out. There is a RunMacro function and that did the trick.

Beyond my abilities.

I have an IF block in a macro. In the IF block is MsgBox("Check Data", 4)=6. If you hit yes it opens a form. I have the form set to run a submacro when you close it. The Submacro is in the same macro after the IF block. I thought if I select no in the IF block it would go on to run the...

See attached. The MDL_MAST table is the data I had to work with. The Delimiters query counts how many semi-colons there are in the field in the ENH_MODEL field in the MDL_MAST table. Table1 is numbers table that is used for the ParseText function. If you run the delimiters query the highest...

Sorry I had a lot going on. My niece wrote a VBA for me that took care of it. Thanks for the help.

For the aftermarket parts I would suggest either the parts manufacturer's site or using Show Me The Parts online catalog interface. There is an option there to search by part number. Possibly a combination of both. Also the big box stores usually have what else this part fits section. For OE...

Are you talking about OE parts, aftermarket parts, or a mix of both?

My way does not work. One model code is paired with 73/23475. Using the Like "*" & [FieldName] & "*" it comes back with both 73\23475 and 3\23. DBGuy, I just added the those codes to the tables and ran the query. Yours does the same as mine.

DBGuy - Thanks for sending that over. The funny thing is that after I posted the sample data up I thought about taking the other data set I was going to link to, combining the coding with the backward slash in the middle and doing what you did in your query.

OK I attached it. #1 is how the data is in the linked table. I can do nothing about that. #2 is an example of how I would like it unconcatenated. #3 is the final format I will put it in so I can query it against another table.

The zip folder is in a OneDrive folder. I tried to post the share link to it but like I said, you need (10) posts to post an image or a link.

Thanks. The stuff I do is mostly what fits what and then a lot of updating and QC'ing the data. I was a mechanic for a long time until I got hurt. Then I moved into an office. I was amazed at all the stuff that goes on in the background to sell auto parts.

The site will not let me post a link due to my post count.

What is the best way to share it? Does it need to be in ZIP folder like when emailing?