aravindhan_3
09-26-2012, 07:23 AM
Hi,
I have table which has 5 Fields
Week No, Sales, Volume, Profit & Cost
I wanted to create a query where the user inputs the Week number and the results comes out. this works fine.
What I need to do is:-
create a Form, in that I have a list box which lists out all the week numbers,
then create another Listbox which should have all the fields like Sales, Volumes, Profit & Cost.
When the user select any week from List box1 and select the fields that he wants from the List box 2, then result should come up.
User may select Week 1, Week 2 etc & Select only Fields Profit & cost and when click ok, the results should come.
Can you guys give me a guidance how do I do this
Regards
Arvind
I have table which has 5 Fields
Week No, Sales, Volume, Profit & Cost
I wanted to create a query where the user inputs the Week number and the results comes out. this works fine.
What I need to do is:-
create a Form, in that I have a list box which lists out all the week numbers,
then create another Listbox which should have all the fields like Sales, Volumes, Profit & Cost.
When the user select any week from List box1 and select the fields that he wants from the List box 2, then result should come up.
User may select Week 1, Week 2 etc & Select only Fields Profit & cost and when click ok, the results should come.
Can you guys give me a guidance how do I do this
Regards
Arvind