Count IF

T

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
 
J

John Spencer

See reply to your previous post

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF 1
Only Calculating Numerics 5
IF then SUM 5
Average with criteria for adjacent cells ? 1
How to do an IF statement that copy data based on a partial match 0
Create if partial match then copy and paste data from one cell to another 1
Formula for evaluating predictions - Fantasy Football League 8
Greater than Less than question! 2

Top