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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.