Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    year for the query (Access 2000)

    How can i set the query or 2006 as a criteria ? the field invoicedate is a date field but puting 2006 in the criteria is not possible. I want to set the query to 2006

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

    Re: year for the query (Access 2000)

    Add a column

    Y: Year([InvoiceDate])

    Clear the Show check box for this column and set the criteria to 2006, or to Year(Date()) if you always want the current year.

Posting Permissions

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