Information générale
Catégorie:
Codage, syntaxe et commandes
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.....
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement