Report showing Primary Key, not value

[antr]

Hi again
I have a query that runs - off the back of this, a report. The query will show a name eg dave however the report will show Daves unique key (eg 3) and not just say dave how do I sort this? I'm not that great at access but learning fast! Thanks

 

[bob fitz]

Add the table that holds the name "Dave" to the query. Create a join between this table's Primary Key field and the field in the query that you are using in the report. Add the field that holds the value "Dave" (from the table that you have just added to the query) to the query and then use this as the Control Source property of the text box in your report.

 

[antr]

Fantastic - that works a treat
Really appreciate it