Help with Search query statement

[froggy]

Hi,
I would like to display records on a webpage and am unsure of the query statement and would like to seek some advise.
I have a lists of contact numbers(home, mobile) and they are from various Sports groups and different teams. Captains from the different sports group will be able to view the details of their teammates of the respective sports they belong to.
An example of what should be returned is shown in the attached file

Database Info:
Surname
GivenName
Sports
Team
HomeNum
MobileNum

Thank you.

 

[FoFa]

Given a selection on a form to select the team, or some field that denotes that identifies the team, lets call it YourTeam

SELECT Surname, GivenName, Sports, HomeNum, MobileNum
from YourTable
where Forms!YourFormName!YourTeam = Team

Basically