Hello,
I have a form with two text boxes where I put two dates.
I have also two queries, both of them work via ODBC.
One query takes the data from 2 relatively small tables and has no issues with the form date range ("Between [Forms]![Form1]![DateFrom] And [Forms]![Form1]![DateTo]").
A second query, that works with 4 big tables, regularly fails if I write the code above. Instead, it goes fast & easy if I manually insert the date range ("Between #08/01/2016# And #08/03/2016#").
I already shifted the ODBC timeout to 5 min (and with the "manual" date range it takes way less anyway), but it doesn't work.
Any idea, please?
I have a form with two text boxes where I put two dates.
I have also two queries, both of them work via ODBC.
One query takes the data from 2 relatively small tables and has no issues with the form date range ("Between [Forms]![Form1]![DateFrom] And [Forms]![Form1]![DateTo]").
A second query, that works with 4 big tables, regularly fails if I write the code above. Instead, it goes fast & easy if I manually insert the date range ("Between #08/01/2016# And #08/03/2016#").
I already shifted the ODBC timeout to 5 min (and with the "manual" date range it takes way less anyway), but it doesn't work.
Any idea, please?