1,105,225 Community Members

Access Query - search date by 1 month in advance

Member Avatar
Newbie Poster
23 posts since May 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]

Hi all ,

I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month.

I have tried the Data Add and datapart but no success


Member Avatar
Nearly a Senior Poster
3,381 posts since Jan 2009
Reputation Points: 515 [?]
Q&As Helped to Solve: 424 [?]
Skill Endorsements: 14 [?]

can you post the code to the attempt, so that we can see what is attempted, else we are shooting blind

Question Answered as of 5 Months Ago by almostbob
This question has already been solved: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: