So I'm working in Access 2003 (SP3) and I have a simple query that prompts the user for a date then returns the results of items that when out of stock on that specific date.
My query only prompts for 1 date.
This works perfectly the first few times without a problem. But randomly it will prompt for my date field, computate the query, then start prompting for the date field again thus doubling the time the query takes to run.
Please help to solve permanently...