I was wondering if anyone could possibly help me wih this issue. I have an access database. In this database I have a massive table that I have created a query off of in order to be able to edit the data because the actual data is write protected.
I am trying to search for certain dates in the table that have been input ex. from m/d/yyyy to m/d/yyyy. I would like to run a query that would filter the results for me.
My basic assumptions would lead me to think that I can run a query as follows;
Expand|Select|Wrap|Line Numbers
- data1.recordsource = "Select * from [table] where (value in column) >= " & date1 & " and (value in column) <= " & date2 & ""
- data1.refresh
Thanks