Search results

Hi Guys, Please find attached my sample database. If you select forms and then click "frmResults". The click the search button. When i select Name from the combo box and enter a name it will return any record with that name. My problem is with the telephone number. I need to be able to...

Hi Guys, Please find attached my sample database. If you select forms and then click "frmResults". The click the search button. When i select Name from the combo box and enter a name it will return any record with that name. My problem is with the telephone number. I need to be able to...

Hi Guys, me again :) I have a master table and a calls table. I have a field in the master table that i would like to update with the results of the following query SELECT calls.guid, master.Name AS customer, Count(calls.guid) AS NoOfCalls FROM master LEFT JOIN calls ON master.GUID =...

Hi Guys - any help is greatly appreciated. I have a customer table and a calls table. I want a query that will show show a customers most recent call. The result must show all the fields in both tables. SELECT Master.GUID,Master.BISource, Master.Name, Master.Postcode, Max(Calls.CallDate) AS...

Hi, Hope you guys can help. I have never used a form before in Access and need some assistance. I have a combo box that holds list values "Name" and "Telephone". I have a text box that users can type in a telephone number or a name. I have a button that will activate the search and a...

Hi Guys, I know you guys can help :) i would like to populate a column of my "master" table with a query from another table. basicially i have a master table that holds customer records. each customer has their own unique guid. the "calls" table holds records of each call made. so...

Hi, Hopefully someone can help. I have a column in a table "mobile" that have values like -07841055223 -07845254123 etc. i need a query that will remove the "0" at the beginning and replace with "0044" any help is greatly appreciated.