打印的问题
要列出昨天的纪录在grid上时,应该是下面这样写法没错吧!?
SELECT 昨天纪录
SET FILTER TO 昨天纪录.dai_date = DATE()-1
GO TOP
Thisform.Userlabel1.Caption = "昨天记录 "
Thisform.Refresh()
如果要输出昨日纪录打印的话,如下.这样写应该没错吧!?
SELECT 昨天纪录
SET FILTER TO 昨天纪录.dai_date = DATE()-1
report form dairy_des noconsole preview
GO TOP
Thisform.Userlabel1.Caption = "昨天记录 "
Thisform.Refresh()
但是打印的结果却是一整个礼拜的纪录......
why!?我已经下了set filter+条件了....
[解决办法]
试试:
report form dairy_des noconsole preview for 昨天纪录.dai_date = DATE()-1