Date diff nresults

How to filter a query by parameter dates , the total for Novemember 2018 minus December 2018 total , because the users will not be able to see the actual quary I have a ttached a parameter form binded to a query which has the details.

The form has two date parameter ( [start date] to [End date]) where they will fill in , for example the difference for December 2018 is calculated the following:

<= Start AND End date

The problem here isntead of start from 30/11/2018 it is start from 1/12/2018, so how do I make sure that the picked results start from 30/11/2018 isntead of 01/12/2018

SalesMonth      salary      Cumm      Commission
Jan-18      10500      10500      2625
Feb-18      10500      21000      5250
Mar-18      10500      31500      7875
Apr-18      10500      42000      10500
May-18      10500      52500      13125
Jun-18      10500      63000      15750
Jul-18      10500      73500      18375
Aug-18      10500      84000      21000
Sep-18      10500      94500      23625
Oct-18      10500      105000      26250
Nov-18      10500      115500      28875
Dec-18      10500      126000      31500

Regards

Chris
LVL 3
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
Chris,

from your description and the data you provided, I just don't understand what it is you are asking?

Dale
Gustav BrockCIOCommented:
If you filter on StartDate > 30/11/2018, you will get values from 1/12/2018.
To include 30/11/2018 use StartDate >= 30/11/2018.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
Happy New Year!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.