SOLVED!
Thanks so much everyone. My original code was:
TimeLeft: DateDiff("d",Now(),[ProjectDeadline],10))
...and I wasn't able to apply a criteria.
I switched "Now()" to "Date()" with no luck, and I was still getting a prompt to input project deadline when I ran my query. Once I...