1,105,225 Community Members

Access Query - search date by 1 month in advance

Member Avatar
GilbertB
Newbie Poster
23 posts since May 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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

Thanks

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

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
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: