I love seeing comments like this.
We pay a company to convert our data into a specific XML format. They require the data be loaded using (11) sheets.
It is what it is. It is not my circus, not my monkeys. There's the way it ought to be and there's the way it is.
I figured it out. Not all the LOAD_* tables have the field "Part Number" in them.
I found this thread here and added gemma-the-husky's code to mine:
Function ClearPartNos()
On Error GoTo ErrorHandler
Dim T As TableDef
For Each T In CurrentDb.TableDefs
If T.Name Like...
I went Create -> Query Design -> SQL view and typed in:
DELETE FROM LOAD_Asset WHERE [Part Number] NOT IN (SELECT [PartNo] FROM PN_Keep)
When I opened the LOAD_Asset table the only data still in the table were for the numbers that matched what I had in the PartNo field of the PN_Keep table.
I have eleven tables that have data appended via queries. All the table names start with "LOAD_". All the tables have a field named "Part Number".
The queries build data for all our part numbers. Sometimes I need data for all part number and sometimes I only want data for specific part numbers...
@MajP - I found this thread after trying to use ConcateRelated on a large data set.
I downloaded a few different versions of the db you posted on here. I tried to run the query "qry_artist_DConcate" so I could see how your code worked. I get #ERR3078.
Any ideas on this?
The first data set I worked with had the FREIGHTLINER - TRUCKS - MEDIUM / HEAVY DUTY so I used:
IIf([Make] Like "* - *",Left([Make],InStr([Make]," - ")-1),[Make])
That worked fine. My boss asked me to see if it would work on another data set. That data set has the HINO (MEDIUM DUTY). I do not...
No because I have makes like Alfa Romeo, John Deere, etc that would split them.
I specifically need it for " - " and " (". And just in case something else came up I could add in a Text(3) to my code.
Sorry, I did not delete it all in my OP. I fixed it and added in Mercedes-Benz.
I want all the characters left of:
- the first " - " which is space, a dash, and then another space. FREIGHTLINER - TRUCKS - MEDIUM / HEAVY DUTY resolves to FREIGHTLINER.
- the first " (" which is a space and a...
Using your example I would just want "Freightliner"
I just went through the data sets that I have samples and it is the two " - ". I did not see anything with more than the two " - ". I do not have all the data sets though so I cannot rule it out. The only thing that is consistent at my company...