Can you please advise on the following.
I have an MS Access query which contains the following fields:
GroupID, GroupName, StartDate, EndDate, CompleteDate. Fields are pulled from a table called tblGroupBusiness.
What is required is to create a parameter of within the query which will display only three months at one time. For example:
As we are currently in the month of March, the query would only display records that have a CompleteDate from 01/01/19 through to 31/03/19. Once we move into the month of April, all records that have a CompleteDate within the month of Jan will be hidden and the recordset would then only display all records from Feb to the end of April.
As this result can be achieved using various methods, e.g., SQL, VBA, Access functions directly into the Criteria line etc, I am happy to receive suggestions in a varied way.
Thank you in advance.