YTD Problem

[Kirsti]

Hi, I have reports that show data for the previous month, and then the same data in a YTD view. The calculation for YTD is: Year([Field1]) = Year Now())



However, actually - I only want to show data from the start of the year until the end of the previous month, so no current month data is included.

The only way I know how to do this is using Between Date and hardcoding '2012', but I don't want to do this for obvious reasons. Is there another way of doing this?

Thanks in advance,

Kirsti

[manic]

Can you give me an example using actual dates?

[ssanfu]

You could try:

..... WHERE Year([Field1]) = Year( Now()) AND MONTH([Field1]) < MONTH( Now())

[Kirsti]

Thank you - that's exactly what I wanted.