Search results

I need to add the additional people's data as seperate fields. I can easily add enough additional columns on to "Main Table" to cater for all of the additional data from "2nd Table), it;s the getting the data in to "Main Table" which I'm unsure on. thanks

Hi Bob, The data needs to be fed in to an old IT system which has to have each property against 1 row. Nothing I can do about this as it's remotely hosted. cheers Glen

Hi all, This must be an age old issue but after searching I cannot find a solution.. I have 2 tables that need to be merged into 1. The "Main Table" holds address information (e.g. client key, type of building, age, value, etc.), the "2nd Table" holds people resident at that address (e.g...

Hi all, Thanks for all your help, now solved with the following code :) Public Function Homer_Simpson(InString As String) As String '***When a numeric is found returns all characters from that numeric*** Dim x As Integer For x = 1 To Len(InString) If IsNumeric(Mid(InString, x, 1))...

Possibly (I'll Google it), although I would still need to know how to deal with them separately?

Thanks Chergh I shall give this a go (although I do not think it will work for all types of postcode format). Pain is there are 1.8 million of them so it takes ages to run on my machine!!! Brian - Unfortunately it is a valid postcode, these are based in London, you also get WC1X 0BH...

I have split out the 2 halfs with the space as the delimiter, however the code is not suitable to then split the 1st half again. I thought it was however it did not extract the correct data for postcode in the format of W1D 8HX. Very annoying but on the bright side as it's very quiet on here...

The objective is to split the postcodes in to those 4 segments to allow them to be uploaded in to a black box (cannot view internal structure) IT system. Therefore the fundemental task is to split them up!

Apologies, the above does not work for all UK postcodes (you can have W1X 8HX), back to the drawing board!!

Just in case anyone ever needs to do the above, here we go...... 1st split the postcode in to 2 parts (using the space as a seperator) so you should have a left split (e.g. SO10) and a right split (1QW). Then use the following code: IIf(Len([Left Split])=4,Right([Left...

VBA help needed to manipulate UK Postcodes Hi all, I'm trying to mainpulate UK postcodes in MS Access (2003 or 2007). What I need is to split UK postcode in to 4 parts, therefore: SO10 1QW would be: SO 10 1 QW M6 5RT would be: M 6 5 RT WC1X...