JANR and Carl,
Ok see this is why I have so much trouble with Access!! I found an error on my part. What a surprise, lol. I was putting my criteria under the wrong field so of course it wasn't pulling and dates up!
JANR - I copied your original reply to my problem and put it into the correct...