Good day all, hope you can help!

I have been toiling with this Query for a while now, and I am sure it will be relatively simple to fix!

I use the query to return all of the values from one table, along with a count of votes from one table, and a count of comments from another.

I have got it to work for loading an individual record 

```
DCount('[query_id]','[comments]','[query_id]=" & Target & "')

```

However if I add something similar to the query that returns every query\_id, the count shows the same for them all.

Is there a different function I can use than DCount to achieve this?

My previous issue was using count, and as the query had non unique data it was counting all votes from a person (i.e if I had made 6 votes, the count would show as 6 for any record my user id was attached to)

Happy to provide any further detail regarding the query.