title: Query Max/Min value shows original values
body: <p>I'm taking the max value and min value of a table composed of Date, Time, and Load.  For example:</p>
  
  <pre><code>Date      |   Time         |   Temp
  -------------------------------------
  1/1/2014  |   09:00:00 AM  |  100
  -------------------------------------
  1/1/2014  |   09:01:00 AM  |  110
  -------------------------------------
  1/1/2014  |   09:02:00 AM  |  120
  -------------------------------------
  1/1/2014  |   09:03:00 AM  |  111
  -------------------------------------
  </code></pre>
  
  <p>....................And so on</p>
  
  <p>I've tried to just use the functions Min(), Max() but these values output the same data as the original table.  See SQL code:</p>
  
  <pre><code>SELECT Table1.Date, Table1.Time, Min(Table1.Temp) AS MinLoad
  FROM Table1
  GROUP BY Table1.Date, Table1.Time;
  </code></pre>
  
  <p>I tried using DMin() and DMax() functions but instead of getting a value I got a null of the values.  I tried the syntax</p>
  
  <pre><code>DMin("[Temp]", "[Table1]", [Time] Between #09:00# And #15:00#)
  </code></pre>
  
  <p>I'm fairly new to Access so any help would be appreciated.</p>
  
  <p>Thanks!</p>