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