Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report based on various criteria

Discussion in 'Information Technology' started by Dendalee, Jul 28, 2006.

  1. Dendalee

    Dendalee
    Expand Collapse
    Guest

    I need to create an "Early Bird" report based on several different fields
    each with it's own criteria. I am having trouble combining the information
    into one query.

    I have one table which lists each youth plans. Weekly, the "early bird" is
    updated and we print a report showing all of what is due and/or late to be
    turned in. We used to do this in excel, but we would like to start tracking
    this information in Access.

    This report has separate fields one is ITP, MTP, MTPU, etc. each report that
    has not been turned in also must include the youth's name & the day it is
    due. i.e.

    Baxter, Dendalee ITP 6/7/06
    Holcomb, Satin MTP 6/22/06

    How can I pull up this information in one report?
     
  2. Loading...

    Similar Threads Forum Date
    The US-based Hindu American Foundation (HAF) releases report on first annual survey of HHR (News Fro Interfaith Dialogues Jul 17, 2005
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Must the results meet ALL of the criteria or ANY of the criteria?

    If must meet ALL then place all criteria on the same row of the query in
    design view grid.

    If must meet ANY then place the criteria on a separate row in the grid.

    "Dendalee" wrote:

    > I need to create an "Early Bird" report based on several different fields
    > each with it's own criteria. I am having trouble combining the information
    > into one query.
    >
    > I have one table which lists each youth plans. Weekly, the "early bird" is
    > updated and we print a report showing all of what is due and/or late to be
    > turned in. We used to do this in excel, but we would like to start tracking
    > this information in Access.
    >
    > This report has separate fields one is ITP, MTP, MTPU, etc. each report that
    > has not been turned in also must include the youth's name & the day it is
    > due. i.e.
    >
    > Baxter, Dendalee ITP 6/7/06
    > Holcomb, Satin MTP 6/22/06
    >
    > How can I pull up this information in one report?
    >
    >
     

Share This Page