I have set up a query using the tables article and user.
I am grouping by user.[user_id] and counting the number of records from the article table related to that useras Articles.
It works, but if a user has no records related to them their user ID does not show up in the datasheet with a zero under Articles.
I simply want it to display ALL user_id's even if the count of fields in table 'article' relating to that user is zero.
Ahh, Thanks a lot.
I didnt fully understand join types till I had a look over the 'evil access help systen' and realised I was expecting a record to show up that wasn't even in my database.
So it works. Just didn't realise until I further persued my imaginary problem.
Thanks again. (should have known a forum would be the first place to ask, could have saved me hours)