Hi!
I am new to this...

I want to display a report based on use input..
I have created a report which has a filter items having a drop down combo box with locations For example: A, B, C, D in it.

I have a submit button next to it which when the user clicks will show the report based on the location selected.

I need to know how to code this. I am using just 'one' table to display all results.

Appreciate the help.
Thanks

Please show us your table definitions (as CREATE TABLE statements) some sample data (as INSERT INTO statements) and your expected output.

And make sure your SQL code is formatted properly in your post using [code] tags.
Details are here: http://www.dbforums.com/misc.php?do=bbcode#code