Recent content by King21

Apologies for not replying earlier. arnelgp, thanks for your suggestion it works great. Thanks to everyone who replied

arnelgp Thanks for the reply Do I put the function into a module, if so how would I call it

I have a field "Address" with the address format as "123 Something Rd, Somewhere, NSW 3456". I would like to be able to extract the location name, which is between 2 comas, using the above example have the location name "Somewhere" copied the another field called "Location" I have tried Mid...

Thanks for the reply isladogs. Thanks for the "Band Aid" solution store the addresses in a separate table tblAddresses each with an auto number AddressID primary key field. I'll get working on the suggestion. Thanks again

arnelgp Thanks for the reply. Not sure if I did this correctly but it works: In the next query cell I entered "Expr1: [Customers].[Address] Like [Customers_New].[Address]" Thanks again for the help.

arnelgp I looked at majp's post again and yes you are correct, it is very similar, isladogs comment "Similar idea to the above but using an inner join rather than a Cartesian join (so should be faster)" caught my eye and followed that suggestion. I just created a query in my DB with majp's code...

Thank you for the replies. Appologies for the late response, been a bit busy isladogs Your code is the solution that I require, SELECT Customers.OrderDate, Customers.Address FROM Customers INNER JOIN Customers_New ON Customers.Address = Customers_New.Address WHERE...

Hi June7 thanks for the reply SELECT DISTINCT Customers.OrderDate, Customers.Address FROM Customers INNER JOIN Customers_New ON Customers.Address = Customers_New.Address ORDER BY Customers.Address; I still get the same results 3 unmatched results

I am trying to compare 2 tables "Customers" and "CustomersNew" to find matching addresses. The objective is to identify an address that we have worked at previously. I have been trying the below code SELECT DISTINCT Customers.OrderDate, Customers.Address FROM Customers RIGHT JOIN Customers_New...

arnelgp Thanks for the reply Works like a charm, thank you

Thanks for the replies Pat Changed the "Address" line of code as you suggested, I get "Compile Error" Expected: End of Statement and it highlights the right parentheses I have tried several methods (comas, parentheses, braces etc.) can't get it to work. Any suggestions MajP Looks good...

arnelgp Thanks for the reply, your code works well. Can the code be refined so that the only results are exact matches. Your code gives many results: If I search for NEAGLES and LAGUNA, it gives all addresses with LAGUNA or if I search for MINTARO and CATTAI it gives 2 results : 26 MINTARO RD...

I am trying to do a multiple search on addresses that are in 1 column. Example: Column "Address" 18 NEAGLES ROCK RD, LAGUNA I would like to be able to search for: NEAGLES and LAGUNA i.e. the Street or Road name and the suburb. I can search on whole address, street name or suburb name, which...

Thanks for the reply arnelgp, silly mistakes gets us every time. Thanks also for the Report "On Open" code that has solved my problem.

MarkK Still trying to get my head around VBA, could you please explain where is the "Private Const SQL As String = _ code should be placed.