Hello All,
I have produced a database that looks at workflow reporting. I'm currently stuck on the following problem;
Say I have a import of accounts into the database that were Un-worked at the time. After some cleaning of duplicates, the data is then appended into a main table (example row below from main table);
tblMain
Work Item date created date end User
1 19/09/2008 31/12/9999 Mike
I then have in a query to look at which are outstanding. This is done by looking at the end_date. If it's #31/12/9999#, then it as unactioned. This works fine. But say I did an import today and the account was cleared, a new row is then created with the end_date inputted (i.e. 05/12/2008).
So when I run the query, I am getting more outstanding then I should. A solution i thought was where there is more than two work items the same, choose the one with the MIN date.
So the query determines if its cleared or not, but the problem is it also picks up ones which have now been completed.
Can someone point me in the right direction please?
________
Live Sex Webshows
I have produced a database that looks at workflow reporting. I'm currently stuck on the following problem;
Say I have a import of accounts into the database that were Un-worked at the time. After some cleaning of duplicates, the data is then appended into a main table (example row below from main table);
tblMain
Work Item date created date end User
1 19/09/2008 31/12/9999 Mike
I then have in a query to look at which are outstanding. This is done by looking at the end_date. If it's #31/12/9999#, then it as unactioned. This works fine. But say I did an import today and the account was cleared, a new row is then created with the end_date inputted (i.e. 05/12/2008).
So when I run the query, I am getting more outstanding then I should. A solution i thought was where there is more than two work items the same, choose the one with the MIN date.
So the query determines if its cleared or not, but the problem is it also picks up ones which have now been completed.
Can someone point me in the right direction please?
________
Live Sex Webshows
Last edited:
