10-23-13, 11:02 #1Registered User
- Join Date
- Oct 2013
Unanswered: New & Old Tables, how to identify new items added?
I have two tables that I compare on a weekly basis to calculate the earned weekly quantitites by variance between the numbers in the two tables: "LastPeriod" and "ThisPeriod." However the "ThisPeriod" table is evolving meaning new data items/Rows (New areas) are added to it regularely. For these new added items, the earned weekly quantities are exactly similar to the new added value. And for these items there was not any corresponding item in the "PrevPeriod" table. Therefore if I use a formula to find the variance between the two tables based on a common key, the formula does not capture the newly added item. Now the question is what would be the best way to identify these newly added items? I have tried "valu=null" or "valu=0" but neighter works. How can I find the items that exist in the new table, but did not exist in the last week's table?
10-23-13, 11:57 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
its all down tot he JOIN
consider using the query wizard to get some ideas
If Im interpreting your problem correctly you want all rows for this period AND rows matching the previous period or possibly all rows which aren't in the previous period
how ytou go about that is down to your design.
you coudl use the propr 'JOIN' syntax or match rows using the WHERE syntaxI'd rather be riding on the Tiger 800 or the Norton