Forum Discussion

CJDataBI's avatar
CJDataBI
Copper Contributor
Mar 13, 2024

How to populate Access query record with text from Form

I have a query which returns sales data between 2 dates (Start Date, End Date)  from 2 text boxes on a form.  

 

I would like to display these 2 dates in the query (Start Date, End Date) to show what dates were used for criteria in the sales report.  I tried below, however it doesn't show anything.  I can just use "7/1/2023

 

Any help would be appreciated!  

 

 

 

 

 

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Please share some of your original data by copy to Excel then copy and paste to a post in text rather than screenshot.
    And show your expected result based on the source table.

Resources