The above query gives the following error message:
You've written a subquery that can return more than one fiel without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.
I have used
group by name
having count(*) > 1
to return what 'names' are entered more than one but i would like to be able to see the 'value' for each 'name' without having to use it in another query.
By the way im useing a Access DB