I have a problem with crystal report regarding sub query how to write this query in VB 6.0 the qurey is
select * from cust,calls where cust.customerid = calls.customerid and callid in (select max(callid) from calls where customerid = text1.text)
thanks & regards
hector lobo