Hi,
I need to compare call data between our network carrier and the calls over the same period on our call logger.
Obviously, I can't provide too much information.
So our "network carrier" will provide the attached fields. And our call logging device will provide the attached "call detail"
Basically, I need to compare one against the other. My initial comparison would be the date/time, however, my network carrier only provides HH:MM and my call detail will provide HH:MM:SS, but this may not be the main compare field. The dialled digits will be the same. So I guess I'm looking for something like.
1. Compare Date/Time (with time variants)
2. If Date matches, and if time is within say 59 seconds.
3. AND the dialled digits match then these calls will be a match.
I'm pretty new on these forums, and also with Access, but happy to learn.
I realise there is no specific information, I may be able to provide some test data if requested. But I thought it would be good to get some ideas for the people that know best...
Many thanks in advance...
I need to compare call data between our network carrier and the calls over the same period on our call logger.
Obviously, I can't provide too much information.
So our "network carrier" will provide the attached fields. And our call logging device will provide the attached "call detail"
Basically, I need to compare one against the other. My initial comparison would be the date/time, however, my network carrier only provides HH:MM and my call detail will provide HH:MM:SS, but this may not be the main compare field. The dialled digits will be the same. So I guess I'm looking for something like.
1. Compare Date/Time (with time variants)
2. If Date matches, and if time is within say 59 seconds.
3. AND the dialled digits match then these calls will be a match.
I'm pretty new on these forums, and also with Access, but happy to learn.
I realise there is no specific information, I may be able to provide some test data if requested. But I thought it would be good to get some ideas for the people that know best...
Many thanks in advance...