Count IF

[Tdahlman]

I have 2 tables that are related by the field [Team ID]. The database is
fantasy football related, just to keep practicing and learning new Access
stuff.

I have a table [Scores] that contains the following fields:
Score ID
Team ID
Opponent
Week
Projected Points
Actual Points
Outcome

The data in [Outcome] will either be "Win" or "Lose".

I want to run a query that counts how wins each team has.

Thank you in advance for your help
Travis

 

[John Spencer]

See reply to your previous post

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County