greater than certain date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to add a query that creates a table on;y with information from a
certain date.

To specific it would be from 01/01/2007, but I don't necessarily want to fix
that date as I want to state anything that was worked on this year.

Any suggestions?
 
Use criteria

Field: SomeDateField
Criteria: >= DateSerial(Year(Date()),1,1)

That should get everything from the 1st day of the current year (as defined
by your system date).

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top