Query Based on Date (2003 SP1)

Topic

New Reply

Hey gang,

I need to write a query that allows me sort donations based on date. In other words I need to know what was donated in 2003. How do I write the query to pull just the 2003 donations? Ive tried the 20042002 criteria in the query but it pulls all the dates.

Any suggetions??

Dan

Reply | Quote

Replies

Add a calculated column to the query:

Year([DateField])

where DateField is the name of the date field from your table. Clear the Show check box for this column, and set the Criteria to 2003.

Reply | Quote