select 年 As 期间_年, 月 As 期间_月, 日 As 期间_日, 凭证类型编码 As 凭证_字, 凭证编号 As 凭证_号, 摘要, 借方本币金额 As 金额_借方, 贷方本币金额 As 金额_贷方 FROM {P01} WHERE 账套ID='2018-001-001' And CDate([年] & '/' & [月] & '/' & [日]) Between #2018/1/01# And #2018-12-31# And 科目编码='1010380504' and 年 is not null ORDER BY 年, 月, 凭证编号
加好友 
发短信
Post By：2019/3/1 11:17:00 [显示全部帖子]
