PASS PARAMETER from form to report
From: peter <misybh_at_tpts7.seed.net.tw>
Date: 2000/08/13
Message-ID: <8n5mgg$k22_at_netnews.hinet.net>#1/1
Date: 2000/08/13
Message-ID: <8n5mgg$k22_at_netnews.hinet.net>#1/1
hi..
I wnat to pass a parameter from form to report..
[Quoted] I set query of my report as following...
SELECT A , B FROM T_AVC
WHERE CUST_NAME IN ( &A)......
I WISH A COULD BE " 'CUST1','CUST2' "
SO.. IN FORM ,I SET the parameter like this....
A:=CHR(39)||CUST1||CHR(39)|| ' , '||CHR(39)||CUST2||CHR(39)
BUT THERE COMES AN ERROR" REPORT CANNT PARSE ......."
HOW TO DO
Received on Sun Aug 13 2000 - 00:00:00 CEST
