We have an application that generates a report based on a table created with VB and a couple of queries, taking user input of name and dates. When the report is run from within the application, we don't get accurate data. Here's the interesting thing.
If I close the report and immediately open the database window (F11) and run the report from there, the information is exactly what I want.
I've wrestled with this thing for months now and can't find a reason and I'm sick of playing with the code. I'm trying to figure out 1) why is it happening and 2) How can I, after running the bad report, conceal that from the user and then immediately run the same report again, which seems to be the trick.