New user trying to pull dates out.

[njosefik]

I am a new user and need help with an easy problem.&nbsp;&nbsp;I have a table that has two rows of data which has been collected over the past five years. One column is the date and the other is an output.&nbsp;&nbsp;I need to pull out only certain rows.&nbsp;&nbsp;The rows I need are the ones which are the earliest and latest date given in each month and each row in which the data point changes by at least 20 points.&nbsp;&nbsp;What would be a good way to go about this or where can I get the info on how to do this.&nbsp;&nbsp;<br><br>Thanks

 

[DougP]

Click on the queries TAB and create a new query.<br>Add your table to the query <br>Drag the fields (columns) you want in your query down to the grid below.<br>Click in the Date column and click the Sort box and click Descending.<br>Run your query it should show the Latest Date at the top.<br>Stop your query.<br>Click in the &quot;Point&quot; field Criteria box and type in &quot;20&quot;<br>Run your query again.<br>It should show the latest date of all points fo 20<br><br>Thats a good start.<br><br>&nbsp;<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.