I have to resubmit my previous question. I need assistance on reports.
I created a reports section for campuses. However, when I run the reports and only want to select one campus for example, it shows all the campuses. Please let me know if I need to send something else as well.
Thanks.
Here is my code:
Here is the select statement:

select * from campuses order by description

but I know I need to include a where clause to
retrieve the information but I am not certain where to begin.
Here is the table that it is coming from:
Table Campuses
Description Code
Salt Lake 001
Test 1 002
Test 2 003
Thank you

Originally Posted by tgmiller5

I have to resubmit my previous question. I need assistance on reports.
I created a reports section for campuses. However, when I run the reports and only want to select one campus for example, it shows all the campuses. Please let me know if I need to send something else as well.
Thanks.
Here is my code:
Here is the select statement:

select * from campuses order by description

but I know I need to include a where clause to
retrieve the information but I am not certain where to begin.
Here is the table that it is coming from:
Table Campuses
Description Code
Salt Lake 001
Test 1 002
Test 2 003
Thank you

You need to have a where clause

Do

select * from campuses where code = 'insertcampusname' order by description

Or is ASP if you are doing it from a form

"select * from campuses where code = '" & request.form("code") & "' order by description"

Thank you,

It works.