Search results for query: *

Thank you What about if my original table structure is Fname Sname Address1 Address2 Locality state Postcode and both address fields required comparison Could you show me the modified code for that schema?

Hi there Can anyone help. I have a database that has name and address details included. I need to find exact address matches, then combine the recipients names at the same address into one record/field with the following criteria: 2 people with the same surname at same address: Fname...

Hi Duane The code works really well, although I get sporadic results when using the "&" character. Thanks again for all your help on this. Regards Duncan

Thanks Andy and thanks Duane Duane, your code is just wat I'm looking for. Thank you so much, will test it out and let you know how I go.

Thanks for the code Andy I can pass the variable "Entity Name" field into the function but how would I go about placing the outputted data into 3 or 4 or more separate fields within Access? I need to export the truncated data to ascii text for use within a DOS based environment. Thanks in...

Hi there Just to reiterate, can someone show me some SQL that would enable me to split the below text into approx 40 characters per block, separating at the next available "&" char? An example is below: Original Data Entity Name M.R BEARD & D.C COCKING & R.L FEWSTER & S.L GILL & J.L NIGHT &...

Thanks for your replies. I'm very rusty with access functions these days, any ideas on what the code should look like. The reason behind the requirement of splitting the fields is for a mail merge application in a DOS based environment (I know, I know get with the times right). But as you are...

Hi there I have a database that has an "Entity Name" field which in some cases is ridiculously long. I need to write a query or VBA function that will allow me to truncate only those records that have more than 35 chars into 3 fields, splitting at either an "&" or " " char. An example is...

That was it! Now works perfectly Thank you very much for you help

Yes, I have copy and pasted the entire code into a new std module.

I have tried the code you suggested, and changed the SQL to the appropriate field/table names, however I get the following error when trying to run the query Undefined function 'Concatenate' in expression My SQL looks like this: SELECT AddressComma, Concatenate("SELECT MailNameJoint FROM...

Hi there I have a 1 to Many relationship between 2 tables where the primary key is a combination of the surname and address. So there is multiple people (parents, children etc) at the same address in my detail table. person1 129kensingtonst person2 129kensingtonst person1 30clasibrookrd...