• Comparison Queries (Access XP)

    Author
    Topic
    #381957

    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

    Viewing 0 reply threads
    Author
    Replies
    • #645879

      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?

    Viewing 0 reply threads
    Reply To: Comparison Queries (Access XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: