How to take value from user to run query

[Waheed2008]

Hi all,

I have got some problem is query. I have a table "Expenses" which has many fields like ID, Code, Date, InvoiceNo, Amount, etc.

Now I want a query that will take Code from user and add the amounts of that code from "Expenses" table and show it up. Taking input from user is easy but the problem is that Codes are lengthy to remember for user, like 50 characters or even more.

Is there any way that some dropdown menu show up to user and after selecting the code from that menu, query run to add-up amounts of only that code??? OR is there some other way around to solve this problem???

Perhaps some form is required or something else.

Please some budy help me in this regard.

Thanks in anticipation.

 

[boblarson]

Perhaps some form is required...

Yep, that's the direction you should go.

 

[Waheed2008]

Thanks BOB,
I have found the way.
Have a nice day...

 

[boblarson]

Thanks BOB,
I have found the way.
Have a nice day...

Glad to hear you got it. You have a nice day too