Have report show only one item from combo box list on report

T

tjsmags

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...
 

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

Football report showing dropped out children 8
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Combo or list box 0
Combo or list box 0
Filter report from combo box to list box 1
Hyperlinking Report Data to a Form Record 2
Only first digit of a number shows on Report i.e., 600 shows 6 10

Top