Search results

Linq, Thanks for the info. I manually put in the end date when I open a new record. The Vendor will either be MTM or Auto Renew. If I have a new vendor today, then on December 5, I want it to be changed to January 5. Will it also update the year? Going to go try that now. Thanks, Kathy

mike60smart I tried what you have but after I type the second line and return, I get an error "Compile error: Expected: = Am I having a "user" problem? :) Thanks.

Thanks Mike60smart - I will try this over the weekend and get back with you. :) Kathy

I have something similar to this. I want the EndDate to add one month on the EndDate date if the MTM is checked. So if MTM is True, and it's November 29, 2019, I want it to add a month when it's November 30, 2019. I tried this...

I finally got it to work. I put Expr1: DateDiff("d",Now(),[Contract-Due Date-Preparation]) then put <=0 in the criteria. Thank you all so much for your help. It's been a long week. :)

Thanks Mark. You are correct that the field is [VMR-Due]. I put in the expression and the answers are either -1 or 0 instead of the number of days past due.

I have the same situation but only want the days that are past due. I've applied the following: =DateDiff("d",Now(),[VMR-Due],0) If I try: =DateDiff("d",Now(),[VMR-Due],<0) I get an error message "expression you entered contains invalid syntax." I only want the number of days past due...

I am today old here. I've been working with Access for a couple of years and self taught, thanks to a lot of reading and youtube videos. I've been reading some of the posts and I know I can be helped here. Kathy:)