General information
Category:
Coding, syntax & commands
Hello:
Thanks for responding but i'm still having some trouble or block
with this select statement. My requirements are
1) my report prints fields from the client table - client.sin, client.fullname,
client.phone1
2) first I have to match the sin from act_plan and Coun_sum where
act_plan.follow_dte isn't empty and coun_sum.casemang or coun_sum.nddety
isn't empty; this result has to match with the sins in the client table
into a cursor and then print to a report based on a selection from a combobox
being if the value is coun_sum.casemang or coun_sum.nddety
Here's my code that isn't working.
select client.sin, allt(client.surname) + "' " + allt(client.firstname) as fullname, client.phone1;
from act_plan ap where (!empty(cs.casemang) or !empty(cs.nddetby)) INNER JOIN coun_sum cs on ap.sin = cs.sin INNER JOIN Client;
on ap.sin = client.sin where !empty(ap.follow_dte)and cs.casemang = thisform.combo2.value or cs.nddety = thisform.combo2.value into cursor repdata
I'd really appreciate your help.....
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only