Solved: Date in Criteria

[stapuff]

Very new to Access so here goes:


I need to get a certian date (month) range. I have the following as my current criteria >Now()-180 which is not giving me the result I am looking for.

I would like the criteria to be something like =Now(Month)-5. To show only Feb - July.

I am having a hard time writting this since I really do not know what I am talking about.

Any help would be appreciated.

Thanks,

Kurt

[stapuff]

I think I have come up with the solution for the problem.

Between DateAdd("m", -5, Now()) And Now()

[Norie]

Kurt

That's exactly what I would have suggested.

[stapuff]

Norie -

I know - I got the answer from one of your posts from another site. I needed to do some more testing before I posted a thank you to you.

Your posted solution had -6 which was not working for me so I change it to -5 and whala.

Works like a charm.

Thank You,

Kurt