Thread: Has it been captured?
09-22-05, 17:58 #1Registered User
- 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.
09-22-05, 18:08 #2Purveyor of Discontent
Provided Answers: 1
- Join Date
- Mar 2003
- The Bottom of The Barrel
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? ***
09-22-05, 22:39 #3(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
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 joinhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON