Hi, as I said I have a table named "data_credit". That table contains columns. Here are some of the columns' names : clientID, duration, purpose, Savings_status, class(good and bad), etc. I want to create a macro named "Statut_client" that have as a parameter the clientID, i.e. when I write statut_client(1215693), where 1215693 is the clientID of 1 client from the table, I want to see as a result the clientid,purpose,savings_status of this client if his "class=good", and I want to see a message that says "bad client" of for exemple some other client I am evoking with the macro has a "class=bad". In other words my macro has to show the values of the following 4 variables(clientid, duration, purpose and savings_status) if the value of the variable class=good and my macro has to show "bad client" if the value of the variable class=bad. I really cannot resolve this problem, that's why I am seeking for help. status_client(1215693) (supposing for this client class=good) then I want the values for clientID, duration, purpose and savings_status. statut_client(312y321)(supposing for this client class=bad) then I want message "bad client" with no other information.
... View more