MS ACCESS & Query

[un]

Pls assist me in building query for this sample table "CONTACT"

Field 1: NAME
Field 2: ADDRESS
Field 3: PHONE
Field 4: Email

The MS-Query shall have give all the rows(Name, address, & phone) where email=a@a.com. I had tried to build a query, but does not returns more than one rows with message box Subquery does not returns more than one value.
[/b]

 

[tuxfan]

Huh? Can you please give proper explanation? I am unable to understand what you want.

 

[it_waaznt_me]

Select * from Contact where Contact.email="a@a.com"

 

[it_waaznt_me]

Hmm.. I didnt suggest Like because he's using a very generic search term .. 'a' is a very common alphabet and most of the email address will contain it ..

 

[un]

thanx it_waaznt_me & emanym
Your suggestion worked...