I am working on a MS Acess 2007 query. One field is based on a two column table, with the values:
I have configured this table to display the second column (the name) and this shows up fine. However when I change the Total to group by 'Last', the value shown is the ID (column 1) rather than column 2.
In a query, is it possible to return the second column when you group by last?