CREATING A REPORT WITH DYNAMIC INPUTS...HELP!!!

[bflemi3]

I have a database that tracks contract requirements per division in my company. The requirements are different for each contract. Is there a way to create a report, or even a form, that would show all contracts or all divisions that have a certain capability without making each contract requirement a column in a table.
IE: show all divisions that have system engineering capabilities.

I would like to be able to input the requirements in one form and look them up or sort in another form.

 

[Norie]

How are you storing the contract requirement data?

Is it in one field or multiple fields?

 

[bflemi3]

I would like to be able to enter it in one field.