How do I show text not ID number in report?

Hi

I have a query in my database to return staff absence by team. As there are three levels of team (Service, Locality, Setting) I used a form with combo boxes for the user to select the criteria (combo boxes are based on tables with 2 columns: ID no and team name).

I have a report generated from the above, but in the service, locality and setting fields, it only pulls through the ID number not the team name. How can I make it just show the team name? (In the query results the name is displayed not the ID).

Thanks in advance for your help!

re: How do I show text not ID number in report?

If you post the SQL of the query used in your report I think it will be clearer what you're working with. It should be easy enough from there.