Quick Search Query from two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables: tblEvaluation and tblCustomer. The tables are linked by a
primary key that resides in tblCustomer (atnCustNo) and is linked to
intCustNo tblEvaluation.

I also have a form that displays evaluation information based on
tblEvaluation. I have a quick lookup dropdown that allows the user to select
the date/time of the evaluation and I WANT them to also be able to see the
name of the client that is tied to that Evaluation. How can I do this? I
currently have the SQL below, but I need to incorporate the field
tblCutomer.chrCustName into the current query.

SELECT dtmEvalDate, intCustNo FROM tblEvaluation;
---
Thank you! - Jennifer

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9421-7f166c66a44e&dg=microsoft.public.access
 
SELECT tblEvaluation.dtmEvalDate, tblEvaluation.intCustNo,
tblCutomer.chrCustName
FROM tblEvaluation INNER JOIN tblCutomer
ON tblEvaluation.intCustNo = tblCust.atnCustNo

(incidentally, there was no reason to use the Suggestion button with this
post)
 
Back
Top