I am not an expert for VBA. But this way should be ok. In a module, do Read/Write file, calculate, then set the variables in Crystal report. Or you can just output a txt file. Or you can use C++/VB/Python to control the Access using Automation. Using google if you meet trouble. :)
Probably Access report is good enough. The whole thing can be automated. 经常 方法
【在 L*******r 的大作中提到】 : I am not an expert for VBA. But this way should be ok. : In a module, do Read/Write file, calculate, then set the variables : in Crystal report. Or you can just output a txt file. : Or you can use C++/VB/Python to control the Access using Automation. : Using google if you meet trouble. :)