Since reading a previous thread that matched my project ("Basic Query Question", MooseMan, thread 701-281213) and posting a question, I learned a litte more on my own. I now understand how to use SQL View in a select query.
I tried the following, to return the members that have donated for FY01, but not FY02. When I run the query it asks for a parameter value for [Fiscal_Year]. Any idea why?
Tables: Master and Donations
SELECT Master.TITLE, Master.FIRSTNAME, Master.LASTNAME, Master.MemberID
FROM Master
Inner Join Donations
On Master.MemberID=Donations.MemberID
Where (Donations.Fiscal_Year="FY01"
And Not Exists
(Select * From Donations
Where Donations.MemberID=Master.MemberID
And (Donations.Fiscal_Year="FY02")
Can someone explain the funcion of the "*", also?
Thanks!
Aimee
I tried the following, to return the members that have donated for FY01, but not FY02. When I run the query it asks for a parameter value for [Fiscal_Year]. Any idea why?
Tables: Master and Donations
SELECT Master.TITLE, Master.FIRSTNAME, Master.LASTNAME, Master.MemberID
FROM Master
Inner Join Donations
On Master.MemberID=Donations.MemberID
Where (Donations.Fiscal_Year="FY01"
And Not Exists
(Select * From Donations
Where Donations.MemberID=Master.MemberID
And (Donations.Fiscal_Year="FY02")
Can someone explain the funcion of the "*", also?
Thanks!
Aimee