Recent content by sparkyboy2406

Hi, if i use the query below i get the correct results. SELECT DISTINCTrow calls.guid, Max(calls.CallDate) AS MaxOfCallDate FROM calls group by calls.guid; but when i add calls.callsidsync or calls.calltime to that query it prints out all the records. The main aim of the task is to show the...

Hi, thanks for the reply, can you give mr an example of how the query will look. I am a bit of a novice at this. Any help is greatly appreciated! Thanks

Hi David, Thanks for the reply. Would i set up a query for this like below qry1 = "SELECT [daytime telephone], [Evening Telephone], [Mobile Telephone] FROM Master " & _ "WHERE [daytime telephone] LIKE *'" & txt_search.value & "'* OR [Evening Telephone] " & _ "LIKE '*" & txt_Search.value & "*'...

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, thanks for the reply. I am sure there must be a way to show all the fields of the most recent call for each customer from the calls table as well as the customer details from the master table. Anyone else have anymore ideas?

thanks for that John. but what i need is all columns from both tables. When i try to add the calls.calltime to either query it will either show all records or as me to enter a parameter value. for the query that you have given me at the minute i want to be able to add the other columns in the...

sorry i forgot to post the database. please find attached.

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 i have attached a sample of the database if that helps Hopefully someone can help me with this issue Thanks :)

Hi Guys Please find attached a sample of the database. Any help is greatly appreciated Thanks

David, I will post this over the weekend. The database is very big so i will have to alter this a bit. thanks

Can anyone provide any help on this problem? cheers :)

Thanks for the replies guys? can you give me an example of the SQL to complete this task? how you use the result of one query in another query? Thanks

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