Access function - TTM of data

[BrownBoy]

Hello all,

Do any of you know the function/formula that will only query the last twelve months in an Access query? Based on the current month.

Thanks.

[Norie]

You could use this criteria.

[DateField]>=DateAdd("yyyy", -1, Date()) And [DateField]<=Date()

[BrownBoy]

Thanks for the quick reply. The answer I get now is either "-1" or "0". Any ideas on what happened?

[BrownBoy]

Got it, stupid mistake. Didn't add it to the criteria, I added it to the field. Stupid.

Thanks.

[Norie]

Glad you got it.

By the way, I'm not 100% sure I posted the exact criteria you want but the function DateAdd is what you need for this sort of thing.