Search results

Perfect it worked. Thanks a million as you saved me much time.

Problem: 4 text in field seperated by comma Objective: Separate each block of text into (4) columns Sample data in Field: Entity/Department/Function/Unit [SHKI, Marketing, Home Equity, Operations] Solution: Column 1: Entity...

I was able to build all four new columns with expressions. Thanks

How do I add the IfError or NZ for the ones that are an error or blank so it wont show #Func!? Function: Left([FunctionString],InStr([FunctionString],", ")-1)

Sample data in Field: [SHKI, Marketing, Home Equity, Operations]

I'm trying to avoid building a function when it should be able to be done with a query expression. If I can't figure it out I will build function.

Yes I did thanks.

Its all different size text split with a comma.

Got the last one now just need the 2nd and 3rd position. Unit: Mid([Entity / Division / Function / Unit],InStrRev([Entity / Division / Function / Unit],", ")+1)

Got the first split. New: Left([Entity / Division / Function / Unit],InStr([Entity / Division / Function / Unit],", ")-1)

Thanks. I'll try to figure this out. I used an expression. Thankfully each ID has same # of characters: Service ID1: Left([Service ID],12) Service ID2: Mid([ Service ID],14,12) Service ID3: Mid([ Service ID],27,12) CMDB Technical Service ID4: Mid([CMDB Technical Service ID],40,12)and so on up 20

Looking for help on a query to help save me time trying to figure it out. The expression needs to break up query into different columns. [Department, Unit, Division, Entity] Field has four sets of data in one recordset. Need to extract Department into separate column, unit in separate column...

After the split how do I get it into the same colum in a separate row?

Example: Table/Query 1 with Multiple fields to Join: Table with Relation: Service ID1 > Service Name Field Service ID2 > Service ID3 > Service ID4 > Service ID5 >

Yes. I just couldnt join the tables to the query. I had to split a field last week (you may have seen my post) into 20 different fields. Each of these field needs to join onto one field on a seperate table which has a unique ID. I was unable to force the join in one single query.

I have a lot of queries which have to be joined by a union however since there are too many columns it reaches the maximum amount of fields defined. Is there any other options I could use to deal with this

Done. I did it I had to create 20 seperate columns. How do I join them. It is not working joining two different fields to one, It says I need to create a seperate query with the join first in order to create the join. Never done something so complicated in relational database. Good for the brain.

I'm going to try to break the field into seperate fields using an expression like this Expr6: Mid([Service ID],79,12). Then I'll have to make a new table from it and link the fields back to the one ID in the relational table. Thanks

I guess I will have to strip out each ID [SvcT_0231018] if there are more than one from a query as it is a relation in another table

1. One table has one field: Some have more than one ID but they are all in one table. [SvcT_0231008;SvcT_0231018;SvcT_0231018;SvcT_300407 5;SvcT_3004375;SvcT_0066191;SvcT_0231018] 2. Second table only has one ID so the ones with more than one ID cannot be linked as a relationship In other words...