list prompts

[nfldbunker]

hi

i have a query subject of diagnosis which contains 1000's of codes and descriptions. I want to use a subset of these codes which meet certain criteria such as falls, scalls, head injuies and car seat accidents  in a select prompt to be used as a filteria in a report.

Instead of showing all diag codes i want to use maybe 100 in prompt list

thanks

bunker

[blom0344]

That is purely a matter of having the proper restrictions on the query that feeds the prompt. There is not a clear distinction here in building a query that is used by a prompt and one that feeds the report with data. (in both cases use filters to restrict values / data fetched)