How to populate Access query record with text from Form

Copper Contributor

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!  







2 Replies



When you click into the seemingly empty columns, do you see kind of "chinese" characters? If yes, then this is an old bug when referencing form controls in queries. One of the workarounds is:




Access DevCon - online conference April 18+19
Access Forever

Access News
Access-Entwickler-Konferenz AEK

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.