J
Jennie
I have a query that lists 84 accounts and the most current date this account
was billed. I need to add a "Yes/No" field, "Yes" if the most current bill
date was in the previous month and "No" if the most current bill date is
prior to that. For example, this is the month of December, for every account
that was billed in November, I want a "yes" in the field, and for every
account that was billed in October or before, I want a "no". I have tried
several ways and can't get it to work. Any help would be greatly appreciated.
Thanks!
was billed. I need to add a "Yes/No" field, "Yes" if the most current bill
date was in the previous month and "No" if the most current bill date is
prior to that. For example, this is the month of December, for every account
that was billed in November, I want a "yes" in the field, and for every
account that was billed in October or before, I want a "no". I have tried
several ways and can't get it to work. Any help would be greatly appreciated.
Thanks!