A Report field that looksup a value

[xyba]

I'd like to know how to create a sort of "calculated" field in a report.

I have my main table, where the report is generated from via a query. I have table 2 which lists staff in one field and their location in the second field, however, the location isn't stored in the main table. I want to create a report that shows various fields from the main table, including staff_name, then look the location up from table 2 and enter that in a location field on the report.

I'm totally new to queries and reports and wondering how to do this.

 

[arnelgp]

is it not possible to include them in the query.

 

[xyba]

is it not possible to include them in the query.

It is. I've just been playing about and found how to do it within the query so sorted now. Thanks.