Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Based on Date (2003 SP1)

    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 2004<or >2002 criteria in the query but it pulls all the dates.

    Any suggetions??

    Dan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Based on Date (2003 SP1)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •