So then I figured, that that might not be all that clear, soooo . . .
you can put this expression in a query:
datepart("m",[somedate])-6 + iif(datepart("m",[somedate])-6<1,12,0)
substitute your date field's name for the word 'somedate' in both places. And adjust the 6 in...