greater than certain date

F

F0zziebear

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?
 
J

John Spencer

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
..
 
Top