I have a form for data entry - and have an unbound text box on the form - formatted as short date. So on the form it has the calendar control to select the date (this is Access 2013). See attached - checkout.
Now I want to use a query to retrieve the values on the form - see attached - Query1
When I run the query everything pulls in as hoped except the date checkbox. It appears blank - if I place my cursor in the field I see odd characters. I assume there is a way to pull the date as it appears on the form - just not sure what I am missing. See attached - Query1Results
Thanks!
Now I want to use a query to retrieve the values on the form - see attached - Query1
When I run the query everything pulls in as hoped except the date checkbox. It appears blank - if I place my cursor in the field I see odd characters. I assume there is a way to pull the date as it appears on the form - just not sure what I am missing. See attached - Query1Results
Thanks!