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.
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
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 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.