>It's a bit complicated but I'll have a try to explain.
>I have an select sql result given and have to sort out one of the fields on the condition of other two fields in the same table.
>Then I have to save them in different excel tables and send them to different places in regard to that condition.
>I thought it could be a quick solution if I sort out them by making the content of the two condition fields into variable in the runtrime and saving the required content of the field into that local variable. And those variables would be saved to the assigned excel table.
Tamas,
please post some example data from that table and what you want as a result.
At least for me that will be easier :-)
You have one SQL resultset and two fields that give you some condition.
Is it possible that these fields can vary in the whole resultset?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.