Search results

Okay, I found a solution, maybe you could comment on that (for learning puroses :))? Seems kind of too complicated....But after all, it works at least! SELECT DISTINCT tblClients.IDClient FROM tblClients LEFT JOIN tblProcesses ON tblClients.IDClient = tblProcesses.FKClient WHERE...

Hello everybody, I'm a beginner and still trying to understand Access' logic. My VBA skilled are very limited. I'd say close to the zero limit :) Today I'm trying to filter a clients list displayed by a query. This query lists all clients that still have no entry (their ID saved as foreign...

Thank you, Beetle. This really is yet another way to do the same, but you helped me a lot however. Now that it's clear my idea can't simply be realized I searched for another solution of my problem. I am using your query for sorting the clients and having a form where they appear in this order...

Hello everybody, I'm new to this forum and - most importantly new to Access (2010). I'm trying to sort a query in a slightly more sophisticated way, and I'm not having much success. This is the scenario: I want clients from tblClients to appear in a query in a certain order. We call those...