Recent content by mary1994

ESquared,i am not that good in SQL. bborissov query works great. My be i am not clear in my explaination. but thanks a million

Thank you so much Borislav. I think i move all of the tables related to this project to Teradata so i can use your sql statement. It works well in sql server, way faster than access. Hope i get lucky again in getting your help if needed. YOU ARE GREAT................

Disregard. I will try to do something using Teradata

No. this is will work in access and teradata INSERT INTO Promotion (EmpName, EmpNo, DeptNo, Sex, DOB) VALUES ('John Smith', 10001, 876, 'M', 560231);

The query below works correctly on a sample database with fewer records but on the production database it is skipping some of the records. Here is my query: SELECT T1.* INTO jump FROM Table1 AS T1 INNER JOIN table2 ON T1.ID=table2.ID WHERE (((T1.amt)<=(SELECT Max(Amt) FROM Table1 As T2...

Thanks. But i should be able to run it within the sql view in access. Just that access sql does not recognize some of the syntax. If you can write it for teradata sql i will gladly use it. I have tried so many access forums with no help. YOUR HELP IS OF GREAT VALUE TO ME and if you can write it...

Thank you very much for your help. Let me apology for not providing you enough information. I will not be using sql application. The project is access and the result of this query will be displayed within a form. I do not need the insert section or the form, just the correct query syntax to pull...

The query below works correctly on a sample database with fewer records but on the production database it is skipping some of the records. Here is my query: SELECT T1.* INTO jump FROM Table1 AS T1 INNER JOIN table2 ON T1.ID=table2.ID WHERE (((T1.amt)<=(SELECT Max(Amt) FROM Table1 As T2 WHERE...

River guy can you please help me with this. I am experiencing the same issue as Scrye. This query was created by someone in the Microsoft Knowledgebase. But for some reasons the sample i posted pulls the correct amount of data but on production it is skipping some records. Here is the query...