Crosstab query for last 6 months

[bowes884]

Is there something I can put into the criteria of a date box to only use the last 6 months. I dont want have have to do this type of criteria: >12/1/2004. I want it to just use information from the last 6 months no matter what the current month is. If anyone knows what I am trying to say, please help me out! Thanks

Bowes

 

[Jon K]

Between DateSerial(Year(Date()),Month(Date()),0) And DateSerial(Year(Date()),Month(Date())-6,1)

will return records Between 12/1/2004 And 5/31/2005 when the query is run in June 2005.
.

 

[bowes884]

Im more looking for somethign that filters information for 6 months prior to any current, non-specific date. Like it will automatically get the data dated from 6 mopnths ago from june, july, august, without anyone having to go in an change the date criteria.

 

[bowes884]

Below is a non working example of what I am trying to come up with. If I could get something like this, it would save me a ton of time going back and updating all the date criteria for my databases.

 

[bowes884]

Below is a non working example of what I am trying to come up with. If I could get something like this, it would save me a ton of time going back and updating all the date criteria for my databases.

Forgot to post it:

>=Now()-Day(180)