Hi all,
I don't know much about MS Access, but I am using it more often recently at work as needed. This is the issue I am dealing with at the moment.
I have created a query that shows some of the data from a database. I've also created a form to open the query. In the form I put on two text-boxes to enter dates, and only the data between them will show. Everything works fine, but I want to create two columns in the query, each of them showing one of the dates I enter in the form. I was just wondering if anyone has the solution to this.
P.S.: Before I upgraded my MS Access from 2003 to 2007, I used to be able to do it by creating a column that says this "Begin Date: [Forms]![data_sorting]![begindate]" in the design view of the query. Now it doesn't work anymore.
Thank you!
Mike