Forum Discussion
CJDataBI
Mar 13, 2024Copper Contributor
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!
Hi,
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:
Eval("Forms!YourForm!YourControl")
Servus
Karl
****************
Access DevCon - online conference April 18+19
Access Forever
Access News
Access-Entwickler-Konferenz AEK- peiyezhuBronze ContributorPlease 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.