Simply Query Help

[corbitt]

I have a simple Access DB, and I need to query two fields from a table (FirstName & LastName).

How do I build a query to return email address for certain first names and last names? I know how to create a query (in Criteria) to return all "Mueller" & "Smith" (LastName), but I don't know how to return only "Robert" "Mueller" & "Rebecca" "Smith"

Thank you,

Jeremy

 

[johnnymac43]

If you want to put the names in the Criteria fields, try this:

SELECT tblName.FirstName, tblName.LastName
FROM tblName
WHERE (((tblName.FirstName)="robert&quot AND ((tblName.LastName)="mueller&quot)
OR (((tblName.FirstName)="rebecca&quot AND ((tblName.LastName)="smith&quot);

If you want to enter the parameter values when you run the query (for only one person at a time) try this:

SELECT tblName.FirstName, tblName.LastName
FROM tblName
WHERE ((([Enter First Name])=[tblName]![FirstName]) AND (([Enter Last Name])=[tblName]![LastName]));

HTH

John

 

[corbitt]

Thanks John. I'll give it a try!

Jeremy