Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Has it been captured?

    Hopefully I get more response on this inquiry than I did on the earlier one today.

    OK. Here's my dilemma/question.

    I am capturing data over periods of time for a particular item. These data can be captured annually, quarterly, monthly, or semi-annually.

    The data are not always captured in in a timely fashion. i.e. for a meausure captured monthly, it may be updated at once with 6 months worth of data. I know this is isn't ideal but this is how the data are available. Trust me it's complicated.

    I want to privide a management report that lists all of the data that should be captured for a measure and display whether or not it has been captured

    for a monthly measurement it might be like
    Month Status Result
    Month 1 captured failed
    month 2 captured passed
    month 3 captured failed
    month 4 not captured
    month 5 not captured

    Does anyone have any ideas?

    My initial thought were to make a table of all of the possible combinations then match the stuff up and create a logical field that determines if the data are captured.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Create an integer table for 1-12 and left join by datepart("m", yourfield). the fields with no value have not been captured.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 5
    Do what Teddy said create that Integer table then join in a query.

    In the Query Window Right Click on the Join(black line) and Edit the Join Properties

    1 only include ......
    2 include all records form TabeA only those From tableB
    3 include all records form TabeB only those From tableA

    you will need to pick 2 or 3 denpening the the way they are join
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

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