Recent content by andydlindsay

You have a spelling error. You want "Fabric" not "Fabirc".

Put your code above in a module. (module code.jpg) Create a query with aliased fields using each of the custom split functions. (query designer.jpg) And your output should be parsed as you'd like it. (query results.jpg)

Did you try creating aliased fields in the query and using [FabricCuttableWidth] in each one? SecondString: CustomSplit([FabricCuttableWidth]) ThirdString: CustomSplit1([FabricCuttableWidth]) FourthString: CustomSplit2([FabricCuttableWidth]) FirstString: CustomSplit3([FabricCuttableWidth])

Use them right in your queries: SELECT CustomSplit ("onextwoxthree") AS SecondString;

It is a VBA function, so it can't be used directly in a SQL query. You can either process the string using Split() in VBA or you can create a custom function which uses Split() and, from what I've researched, you can use custom functions in SQL queries. There's an excellent answer on Stack...

Don't bother with Replace() then, use Split() instead. Give it a delimiter of "x", and you'll get an array of 4 strings which can easily be stored into separate fields in your db.

Replacement should help you in this case. My understanding is that you want to turn this: 14 1/4Lx3Wx18 1/2Ix1V Into this: 14 1/4L 3W 18 1/2I 1V It seems to me that if you replace every instance of 'x' with an empty string (""), you would achieve the desired output.

It sounds like what you need is something quick and dirty (aka not normalized). Why don't you create a price range table as you have defined them and reference that table with a new foreign key field in Wijn (your base table) called PriceRangeID? Each record in Wijn will then have a...

My suggestion (and the way that I have done it in the past) is to use Append queries. Design the tables how you would like them designed then query your existing tables for the appropriate info and append to your new tables. Another suggestion: try not to work within your exisiting database...

Hi Kristen :) I have attached an example of how you could rework your database using many to many relationships. An employee can work many jobs and a job can have many employees working it... or an employee can have many certifications and a certification can have many employees. One of the...

I was having this exact same problem: the subreport looked brilliant in layout view and report view, but in print preview (and on the subsequent printout) only the first record would appear. My subreport was exactly lined up with the edge of the detail section of the main report (for clarity: my...