Number/Text change

[rarejoep]

I've made a report which shows results of trainees sorted by Group they're in. The groups are called A and B. In tables and queries they look like A and B, but in the report they are called 1 & 2, and this is nog what I want. Does anyone know how I should change this?

 

[Pat Hartman]

I presume you have a group table that has a groupID and a groupName. Change the report's query to join to the group table on groupID and select groupName. Then you will have both the numeric groupID and the text groupName available in your report.

 

[rarejoep]

That's what I do: I select the GroupName, that is A or B. But in the report I see 1 or 2...

 

[rarejoep]

Is it also possible to use some code that shows an A if it's a 1, and a B if it's a 2??

 

[Rich]

The control is bound to the wrong column, try opening the query on its own to see if the GroupName is shown there, if it is then delete the original textbox and drag the correct one fom the list