Recent content by Bassman

I've got a fairly simple query. I'm attempting to pull some data based on a "FirstEffectiveDate" and a "CancelDate". What I'm doing is comparing the amount of time an insurance contract has been in-force. Unfortunately, if it is still in-force, the "CancelDate" field is blank/null. What I've...

Just signed up to get some help. My main job is not database management but we're a small company and part of what I do is manage a database I created as well as run some of my own Access queries. Most everything I've learned has been on sites like this. Bassman