Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Flag for Zambia asked on

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
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
Dale Fye

Chris,

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

Dale
ASKER CERTIFIED SOLUTION
Gustav Brock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Gustav Brock

Happy New Year!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck