Hi Friends

 please try to find some solution of my problem.


It's like ... I have three listbox and textbox . The values in the listboxes are..

List Box1     List Box2      TextBox        ListBox3

Amount        Equal                                 And
Date            Not Equal                           Or
                  Greater Than      

                 Less Than     
          
   


 Two Buttons 
   Add Query  Run Query


Now What I want---->

User selects "Amount"(Listbox1), "Equal"(Listbox2), Types("5000") in TextBox and selects "And" (Listbox3)
and then Presses Button "Add Query" , it should acutually show the user like 

"Amount Equals 5000 And" on the screen   (How????)

 then user selects some other values in list boxes and it should keep building the list and we have keep 
showing  the user. So the List could be like finally 

"Amount Equals 5000 And" 
"Date" Greater 12/11/2002 or" 
"Date  Lessthan 15/11/2002 " etc......( which i don't know how to.......)

 

Finally Hit The Run Query (Button2) To actually get the data.


Any Idea how to show user all these query on the SCREEN  (I DON'T UNDERSTAND HOW TO CAPTURE ALL THESE VALUES)


on the screen so that user knows what he's building..some think like 


"Amount Equals 5000 And" 
"Date" Greater 12/11/2002 or" 
"Date  Lessthan 15/11/2002 " etc......


as long he's building the query.


And finally build the whole query as one query and get the data from the database.

Any help or any code or any link would really be appreciated.

 

 

 

 

 

 


 




---------------------------------
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs