-
Solved: Date in Criteria
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
-
I think I have come up with the solution for the problem.
Between DateAdd("m", -5, Now()) And Now()
-
Kurt
That's exactly what I would have suggested.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules