Search results

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...

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...

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...

I have a form "FrmSearch" that searches table "Customers" and lists the results in a subform, I would like to open a report, then to export these results to a PDF file. "FrmSearch" has an unbound control "txtcriteria" a "Search Button", an "Export Button" and an imbedded subform "FrmSubSearch"...

I have been putting an Access Data Base over the past 2 years, learning on the fly by reading books and forums. I live in a northern suburb of Adelaide South Australia. Geoff