This content has been marked as final. Show 5 replies
I have a simple problem and can't seem to work it out. I have a table that has [CW ID] and a month value. The data is updated once at the beginning of the month with the previous month's data which means that from March 1 until April 1 the table will only contain data up to and including Feb and on April 1 the March data comes in.
I am trying to do a count of [CW ID] but only for the mac month in the data and can't seem to get the code working.