Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparison Queries (Access XP)

    Hello and a big thank you to all of you for your help. I want to create a "comparison query" for lack of a better term. I have a query that tells me the numbers of units sold on each day. Now I would like to create a query that will show me what each item has done over a specified period. The period could be preset to a weeks time, a month, a quarter, a year.

    I don't really have a clue as to where to begin.

    Bret

  2. #2
    Lounger
    Join Date
    Jun 2002
    Location
    Anderson, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparison Queries (Access XP)

    One way would be to do a query and in the critria of the date field put something like
    Between 01/01/02 and 12/31/02.....
    does this help?

Posting Permissions

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