Recent content by Claire31415

Aha! That's got it. Thanks so much - I've forgotten as much as I ever did know after all this time hahaha. (The +0 was obviously unnecessary... just a leftover bit from an older query I'd been basing the current on on)

Thanks for the fast replu, but I've tried adding as you specified but it's giving me a #error for every count now. Clearly still not quite on board with the syntax. SELECT PRODUCT.PROPNUM, PRODUCT.P_DATE, PRODUCT.GAS, DCount("*","PRODUCT","[PROPNUM]='" & [PROPNUM] & "' And [P_DATE]<=#" &...

Hi everyone! I've done some searching and I am getting close to a solution but I just can't seem to get it quite right. I need to count the dates in order until the ID code changes. Sounds easy, but I just get zeros when I run. I'm pretty sure it's because of the date format, but I'm at a bit...