Reputation: 153
Filtering dates in Access queries?
I'm building a report for a client. The report is not very complicated, just shows a bunch of stuff requested by the clients. One of the things I'm stuck on is... I need to be able to search by Transaction that took place between today and 6 months back. So when user click on Transaction report, it only shows the last 6 months from today. Anyone have any idea? I'm trying to build a query with that criteria, but I have no idea how it should be.
Another part of the report lets the client choose dates for the report (FROM & TO) and that's not too bad because I'm passing these values to a blank form and then using them in the report. However, here I'm having a hard time figuring it out.
Upvotes: 1
Views: 50
Answers (1)
Reputation: 153
=DateAdd("m", -6, Date()) This fulfills the requirements in my application
Upvotes: 1
Related Questions
- Complex fill in the blanks query in MS Access 2010
- Query Criteria Input Via Form
- Evaluate eligibility of clients based on active period
- MS access iif statement
- Access reporting with queries?
- Building queries in Access 2007?
- MS Access report with data from two tables
- How to join two queries with different GROUP BY levels, leaving some records null
- In Microsoft Access 2010, how do I reference a bound control in a report?
- MS Access - How to show dates officers participate in skill test