How to display information from (date A) - (date B)? (1 Viewer)

Hello,


I have a section on one of my forms for Profits, and i want to be able to view the profits from 01/01/2017 - 10/01/2017.



How would i go about doing this, and also have the option of it adding up these profits from time A to time.



EDIT:
After researching a little, do i create a querie to do this?






Thank you!

Yes, you would create a query to do this. If you want to hard-code those dates the criteria would look like:

Between #01/01/2017# And #10/01/2017#

Most of us would use a form to gather the user input. That would look like:

Between Forms!FormName.FromDateTextbox And Forms!FormName.ToDateTextbox

I also found this info on the MS Office Support site very useful:

https://support.office.com/en-us/article/Use-parameters-in-queries-forms-and-reports-8209eb5c-1589-42e2-9b20-4181f4c7a356[/url]