dates in a query

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

In new to access and I want to make a query that only view from 10/01/06 to
present. How would I do this? Any help would be greatly appreciated. Thank
you in advance.
 
Amanda said:
In new to access and I want to make a query that only view from
10/01/06 to present. How would I do this? Any help would be greatly
appreciated. Thank you in advance.
Click to expand...

SELECT *
FROM TableName
WHERE SomeDateField >= #2006-10-01#
AND SomeDateField < DateAdd("d", 1, Date())

The last line is needed IF your date field will ever hold date values in the
future; i.e. greater than today. If that is not the case then that last
line can be elimnated.
 
Hi Rick,

Thank you, where do I put this information. I'm sorry that I need exact
information.

Thanks, Amanda
 
Back
Top