Search results

  1. R

    Query table using data from same table

    Thanks PKJ. It almost worked! But you inspire me to get a not-so-elegant solution. Here it is: SELECT Mail.Id, Mail.Number, Mail.Type, Mail.Description, Mail.mailDate FROM Mail WHERE Mail.Id NOT IN (SELECT A.Id FROM Mail AS A, Mail AS B WHERE (((A.Number)=[B].[Number]) AND ((B.Type)="Received")));
  2. R

    Query table using data from same table

    Hello, I have the following Mail table: Id Number Type Description mailDate User 4 101 Inbox Aaaa 22/04/2010 Reception 5 102 Inbox Bbbb 22/04/2010 Reception 6 103 Inbox Cccc 23/04/2010 Reception 7 102 Received Dddd 24/04/2010 John "Inbox" is the mail that arrives at the...
  3. R

    Query with sum of criterias

    Thanks a lot!! I never thought that was that simple. Also thank you for your time building an example. Really.
  4. R

    Query with sum of criterias

    Hello! I have a Folder table like this: Id/Name/Client 1/Aaaa/ASD 2/Bbbb/FGH 3/Cccc/FGH 4/Dddd/ASD 5/Eeee/ZXC ...and a Clients table like this: Id/Client/Related 1/ASD/ 2/FGH/ASD 3/ZXC/ASD I want to query the Folder table. If I select ASD as criteria , i want to filter all the folders...
Back
Top Bottom