Search results

I have the following code which moves records from one table to another one based on a if condiction. However, my isnert statement does not work and when I run the code it is aksing for the value of the fields which is supposed to come from the do while selected record on the first table...

Hi thanks, how I will end with the "With" / regards,

Hi, I am geeting "loop without do" error message for the code below which looks like right. please can you help Dim myDb As Database, MySet As Recordset, MySet1 As Recordset Set myDb = CurrentDb() Set MySet = myDb.OpenRecordset("Table1", dbOpenTable) Set MySet1 = myDb.OpenRecordset("Table2"...

Hi, I have actually done your suggestion and this is how I got the query above. Can you please let me know which part of the query is wrong? thanks, ozgur

thanks, I got the following query but does not work; DELETE Salaries* FROM Salaries WHERE (((Salaries.CompanyId) IN (select CompanyId from Companies) and (Companies.Industry= "Finance")));

Hi, I have two tables Table1 and Table 2 which have a common field called "CompanyId". In addition, table 1 has also a field called sector. I would like to deleted the records from Table2, if their corresponding sector in Table1 is Finance. How I can write a simple delete query? thanks, ozgur

Hi, I am new with queries and need some hlpe. I have tow tables. Companies and Salaries. The salaries table has the following fields. Salaries.CompanyId, Salaries.EmployeeId, Salaries.Position (can be manager, supervisor and officer) Salaries.Year, Salaries.Salary, Salaries.Bonus...