MattioMatt
Registered User.
- Local time
- Today, 04:53
- Joined
- Apr 25, 2017
- Messages
- 99
Hi all,
I have a table called tblAppInventory to which I upload data from Excel spreadsheets at the end of each month. The columns in my table and sample data are as follows:
ID | AppID | AppName | AppDeveloper | CodeTestingStatus | NumbOfVuln | DataDate
1 1004 AppOne Internal Passed 0 31/03/2018
2 1005 AppTwo Internal Failed 5 31/03/2018
3 1004 AppOne Internal Failed 2 30/04/2018
4 1005 AppTwo Internal Failed 5 30/04/2018
What I'd like to do is create a query where I can compare data differences between two dates so I can see where any data could have changed between the set of records.
For example, I'd like a query to show me that ID 3 / AppID 1004 has changed as the code status has changed from passed to failed and the NumOfVuln has changed from 0 to 2.
I'm struggling to understand how to do this and I'm wondering if you can offer some advice on how to do this?
Thanks in advance!
I have a table called tblAppInventory to which I upload data from Excel spreadsheets at the end of each month. The columns in my table and sample data are as follows:
ID | AppID | AppName | AppDeveloper | CodeTestingStatus | NumbOfVuln | DataDate
1 1004 AppOne Internal Passed 0 31/03/2018
2 1005 AppTwo Internal Failed 5 31/03/2018
3 1004 AppOne Internal Failed 2 30/04/2018
4 1005 AppTwo Internal Failed 5 30/04/2018
What I'd like to do is create a query where I can compare data differences between two dates so I can see where any data could have changed between the set of records.
For example, I'd like a query to show me that ID 3 / AppID 1004 has changed as the code status has changed from passed to failed and the NumOfVuln has changed from 0 to 2.
I'm struggling to understand how to do this and I'm wondering if you can offer some advice on how to do this?
Thanks in advance!