title: MS Access Query problem?
body: <p>I am using this query:</p>
  
  <pre><code>SELECT D.Generic, D.Ww, D.Dd, D.Plan, c.TotalScan, D.Plan - c.TotalScan AS Balance
    FROM TableA D
         LEFT JOIN (
                    SELECT COUNT(a.Specific) AS TotalScan,
                           b.Generic, a.Dd,a.Ww  
                      FROM TableB a 
                           INNER JOIN TableC b 
                              ON a.Specific = b.Specific
                     GROUP 
                        BY b.Generic,a.Dd,a.Ww 
                     WHERE DATEDIFF(DAY, a.TransactionDate, GETDATE()) = 0
                   ) c
            ON c.Generic = D.Generic 
               AND D.Ww = c.Ww 
               AND c.Dd = D.Dd
   WHERE DATEDIFF(DAY, c.TransactionDate, GETDATE()) = 0;
  </code></pre>
  
  <p>to filter all records that is a insert in my sqlserver database.</p>
  
  <p>Now i am having a hard time how can i do it ms access.</p>
  
  <pre><code>1. DATEDIFF(Day, TransactionDate, GetDate()) = 0  -- Not Work on MS Access(Which Filter all Records inserted in current Date) 
  2. Cant display TotalScan from subquery
  </code></pre>
  
  <p>Example Output Date:</p>
  
  <pre><code>TransactionDate
  3/21/2011 7:26:24 AM
  3/21/2011 7:26:24 AM
  3/22/2011 7:26:24 AM --
  3/22/2011 7:26:28 AM --
  3/22/2011 7:26:30 AM --
  3/22/2011 7:26:32 AM --
  3/22/2011 7:26:35 AM --
  </code></pre>
  
  <p>if my date today is 3/22/2011 5 records will be displayed.</p>
  
  <p>Thanks in Regards</p>