I have a question for a report which I cannot figure out. I have a table with columns (Title, vm1, vm2, vm3) holding account numbers. A company can have one or more accounts and account numbers can be listed in one or all the 3 columns. How can I display the fields where an account has been listed?

Example
Title vm1 vm2 vm3
MD 10 15 25
BOA 25 20 .
Citi . 33 10

If I select account 10, I need a return of all complany titles and columns where that account has been listed.
Which should be MD and Citi.

This message has been edited. Last edited by: Kerry,

With "If I select account 10 ...", do you mean you have a drilldown on that column??

If yes, in the fex that's is executed by the drilldown, you could do something like:
(let's say &ACNUM = 10)

....
WHERE vm1 EQ &ACNUM OR vm2 EQ &ACNUM OR vm3 EQ &ACNUM ;
....

Yes, I have a dynamic list dilldown on vm1 (column),
T2 = tablename, vm1 = column name, ACNUM = Data or account #( since it is a dynamic list, the ACNUM will be selected from the dropdown list pointing to column - vm1
e.g
WHERE (T2.T2.vm1 EQ &vm1.(OR(FIND vm1, T2. T2. vm1 IN T2)). vm1. )
WHERE vm1 EQ &ACNUM OR vm2 EQ &ACNUM OR vm3 EQ &ACNUM ;

I have tried what you wrote but it gives me only records from vm1

And what happens if you comment-out the first WHERE statement ??

I have been out of the office, but I would like to update this request, I used FreSte code and it works great. Thanks FreSte