I have a football 'camp roster' report that shows each child I have inputted
in the 'football players' table. I have a table for 'division' which allows
you to select FLAG, 70LB, 80LB, 90LB, etc.

I want this 'camp roster' report to show ONLY FLAG children names. I have
the 'division' combo box in the report header (showing that this is FLAG
players), but how do I tell it to only show me FLAG players, as it shows me
all the football players in the table?

The ROW SOURCE TYPE says Table/Query and the ROW SOURCE says SELECT
Division.Division FROM Division;

I can't figure out how to tell it just to give me FLAG...