Parameter Lists Question
Posted: Thu Jan 06, 2005 12:08 am
Is there a way to present the user with a list of options for a parameter, where the list is generated from the discrete values found in a field that is part of the table that the report is based on?__ IE, in a table of stock items, there is a field which lists the department. I want a user parameter for the department, so that the report lists all stock items in that department. There are more than 25 departments, so I can^t manually create a list, plus if any of the departments changed, it would require editing of the report. Instead, I would want to populate the list with a simple query like SELECT DISTINCT department FROM stocktable.__ Is this possible?____ Thanks,__ Randy__