方法如下:

奇数行:where id mod 2 =1
即:Select TablTravelExpense.* FROM TablTravelExpense Where ((([id] Mod 2)=1));
偶数行:where id mod 2 =0
即:Select TablTravelExpense.* FROM TablTravelExpense Where ((([id] Mod 2)=0));
表中如果没有ID,则增加自增字段ID就行了