We have encountered a problem after converting to Access 2010. I will state a problem summary here but I am attaching the details in the file that is attached with this question.
Regaring a form we call "Fill Rates" after entering a "Ship Date" range, then entering a site code, and then putting an "x" a field called "PT Group" noting happens. The SQL code is created dynamically. Upon examing the code there are spaces that get inserted into the dynamically created code which is cauing this report not to run. This worked fine in Access 97. Please see the attached files for the details.
Weekly_fr_Frm_Screen.docx Shot is the 1st file that will show you what we enter.
Code_details.docx show the code where the spaces appear after the idh_ that is in red.
Please let me know if you can offer any suggestions.