Querry transactions for prevoius 6 months

[SeanITFC]

Hi,

In access help I've found the phrase for 6 months from todays date:

Between Date() And DateAdd("m",6,Date())

But what is the phrase for 6 months before todays date (Not 'DateLess' or 'DateMinus')

Thanks

SeanITFC

 

[ColinEssex]

DateAdd("m",-6,Date())

Col

 

[Graham T]

Sean

Try:

>=DateAdd("m",-6,Date())

HTH

 

[SeanITFC]

Many Thanks

Many Thanks for your help