Thaks but that is not what i'm looking for the code works (1 Viewer)

[icedearth]

Thanks! But that is not i'm looking for i have three coumns in a query one is the expr above the other one is the number of the bank that if is equal to the expreesion gave me the result of the third column that has the name description

 

[Brianwarnock]

 

[georgedwilkinson]

Alrighty then.

 

[dkinley]

I think in response to my answer on his/her other thread ....

http://www.access-programmers.co.uk/forums/showthread.php?t=158707


-dK

 

[gemma-the-husky]

icedearth

i think the problem is, is that its not clear what you are trying to achieve

so, if you have taken the three character bit, then your query will show this, in the results.

if you want to limit the number of rows, based on this number, you need to put something in the criteria row of that column, to get what you are looking for.

on the other hand if the 3 figure number relates to another table, then you need a second query, based on this query, to link the 3 figure number ot your other table

ie you probably cant do it directly in one query