如何用追加查询自动追加编号？

Henry D. Sy

1.把查询分两步
即按where a.MenuToCycleCode=700001先建立一个查询作为原表，然后追加到目标表
2.用ado循环追加

Henry D. Sy

假设新建立的查询为AA
那么AA的语句应该是

1. SELECT tblMKCycleToMenuDetail.*
   
2. FROM tblMKCycleToMenuDetail
   
3. WHERE (((tblMKCycleToMenuDetail.MenuToCycleCode)=700001));
   

复制代码

然后，追加语句如下：

1. INSERT INTO tblMKCycleToMenuDetail ( MenuDetailChName, MenuDetailCode )
   
2. SELECT a.MenuDetailChName, (SELECT count(*)
   
3. FROM tblMKCycleToMenuDetail  b
   
4. WHERE b.MenuToCycleCode=700001 AND b.id<=a.id)+DMax("MenuDetailCode","tblMKCycleToMenuDetail") AS 表达式1
   
5. FROM AA AS a;
   

复制代码

Henry D. Sy

当然，你想要写成一个也可以

1. INSERT INTO tblMKCycleToMenuDetail ( MenuDetailChName, MenuToCycleCode, MenuDetailCode )
   
2. SELECT a.MenuDetailChName, a.MenuToCycleCode, (
   
3. SELECT count(*)
   
4. FROM tblMKCycleToMenuDetail  b
   
5. WHERE b.MenuToCycleCode=700001 AND b.id<=a.id)+DMax("MenuDetailCode","tblMKCycleToMenuDetail") AS 表达式1
   
6. FROM [SELECT tblMKCycleToMenuDetail.*
   
7. FROM tblMKCycleToMenuDetail
   
8. WHERE (((tblMKCycleToMenuDetail.MenuToCycleCode)=700001))]. AS a;

复制代码

jakyky

Henry D. Sy 发表于 2011-12-29 13:49
假设新建立的查询为AA
那么AA的语句应该是然后，追加语句如下：

好嘞，终于解决了，灰常感谢。