How to populate Access query record with text from Form

Question

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!

karl_donaubauer · Answer

Hi,
&nbsp;
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")
&nbsp;
ServusKarl****************Access DevCon - online conference April 18+19Access ForeverAccess NewsAccess-Entwickler-Konferenz AEK

peiyezhu · Answer

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.

Forum Discussion

How to populate Access query record with text from Form

Share

Resources