Hi friends I'm new on this forum and with access and I have a problem with queries I made two tables one with names and index numbers and another one with the same name and and other staff like places,dates and so on now my problem is that after I go to queries then design view and there is every thing there now under Criteria I wrote Like"*"&[Enter firstname or any part of name]&"*" so that I won't have to wriet the whole name every timeand that woks fine now the hthing is that I wish that besides wirting name I wish I could enter the index number and have the same result I explain when I write Jo the program can find John that's no problem it works fine but John has an index numder of let's say 34 can I in the query box write 34 and the answer is John if yes can anyone the me how it should be writen instead of this Like"*"&[Enter firstname or any part of name]&"*" Thank a lot and sorry for writing so long I hope it could be understood Regards Maxx3