erdal
|
| Posted: 05/15/2003, 12:56 AM |
|
code
CCdlookUp("SUM(betrag)","kasse1","reiseburo='"&reiseburolist_reiseburo_no.value&"' , reiseburokasseid="&kasse_id.value , DBSALES)
error desc.
Source: CCDLookUp function
Command Text: SELECT SUM(betrag) FROM kasse1 WHERE reiseburo='5' , reiseburokasseid=12
Error description: Line 1: Incorrect syntax near ','. (Microsoft OLE DB Provider for SQL Server)
help :)
|
|
|
 |
infotba
|
| Posted: 05/15/2003, 1:35 AM |
|
Hi,
If you are from TR , please send a mail toinfotba@yahoo.com
It is very difficult to find a CC user here.
Regards,
|
|
|
|
rrodgers
|
| Posted: 05/15/2003, 5:48 AM |
|
Try changing the Comma in the WHERE clause arguement to an OR or an AND depending on what your needs.
CCdlookUp("SUM(betrag)",
"kasse1","reiseburo='"&reiseburolist_reiseburo_no.value&"' AND reiseburokasseid="&kasse_id.value , DBSALES)
|
|
|
|
|
