Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page