I have a nice robust access tool that compiles and creates ~200 various reports and graphs based on users' data in Access tables. Recently, one user asked me to transition the backend from Access to SQL. Converting the tables, while not complicated, was tedious. Now that the tables are complete and working, I started running reports. AAAAAAAAAHHHHHHHHHHH! ! ! ! !
Is there a "simple" or other means of passing parameters gathered on a form into a query? The reports still look marvelous, but the data presented sucks. LOL
If you can just point me in the right direction, and/or recommend some worthwhile reading, I would be forever indebted!
Thanks in advance.