Return data for last 6 months

[Brianfree]

Hi, i have a table with parts information, qty and a date. I need to return data where the date is within the last 6 months. Also on another query return data for 6 - 12 months

Please can anyone reply with some sample code...

Many thanks,

Brian

 

[HarleyQuinn]

If I were you I'd have a look at the DateAdd function. Something like:

WHERE YourDate >DateAdd("m",-6,Now())

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.