Results 1 to 2 of 2

Thread: Report design

  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: Report design

    Greetings,

    I have a main form called HouseHold and a subform called Applicants.
    In my subform (Applicants) I have a field called AppType with drop down PREGNANT, CHILD, POST PARTUM. And another field in (Applicants) subform called AppStatus, with drop down NEW, DSS, REDETERM.
    Im using access 2000 and Im trying to get the following in one report for the whole year (Jan-Dec)

    AppType

    1. All Applicants
    2. Pregnant
    3. Post Partum
    4. Child
    5. DSS-Pregnant
    6. DSS-Post Partum
    7. DSS-Child

    I got the first four right, but wasnt quite sure how to accomplish 5, 6 and 7.
    I also want to show what percent of Pregnant applicants were in Jan, Feb etc, what percent of Post Partum in Jan, Feb etc.

    Thanks in advance!
    DD

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It woule help if you would include the sql code for the query as you have it currently.

    blindman

Posting Permissions

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