Hi there! Again, thank you for all your help with this. Normalization has been a challenge. This project changed weekly, and I had to accommodate my boss's crazy way of thinking. It has been quite the road and like I said in a previous communication, I think this is more of a hobby for her. She...
I made a spreadsheet with all the data, but I am not great at pivot tables. I tried to attach the Excel document, but it is not allowed (I need permission to download it). The report consists of 12 sub-forms to make it look like one form. A copy of the report showing the columns and rows is...
Hello, I finally had a chance to look into this and gather the information you need. I already had something close to what you asked for, but made some tweeks to accommodate the exact details. The following query is under qlkpStandardActionsPointsByLoop_ALLTEST. Here is the query
SELECT...
Hello, Thanks for hanging in there with me. Work has been overwhelming, and I haven't had any time to dedicate to this project. I will try to do better starting next week. Thanks!
I want you to know how grateful I am for all the help you have given me over the last weeks and months. You have saved me numerous times and I know this most recent problem has been a problem.
If you cannot help, I understand. Otherwise, I would genuinely appreciate the opportunity to explain...
The points are all about accountability. After reading the one comment I sent you, I can understand the confusion. I had to understand this a long time ago, but I do remember how confusing it was when we first started. When the client is filling out their reporting form, whether they complete...
What can I do to help you understand this better? I, too, have struggled with this. The person who came up with this idea approached me a long time ago. I genuinely think this is more of a hobby for her. I have been working slowly on this application for years and she keeps finding things to...
Yes, because of the points. Not only are they being calculated on the form, but they are also being stored for tracking. They get points for checking the yes and no fields and then another point if its a yes.
Hi, I am sorry this isn't easier to understand. Let me try again.
With this report, I am pulling the points earned throughout the weeks of the program. The points are put in with the "Enter User's Progress" button on the Main Menu and filling out those forms. The report lists planned points...
It is a poor design, but making a crosstab for all those fields is beyond me, and that was the only way I could get it to work. But it doesn't work. If you have more time to take a look at it, I would greatly appreciate it.
As far as the other report. You asked me to show you the query that pulls all the data. The report is Weekly Progress by Standard Action, and I am using twelve sub-reports to get all the data for all twelve weeks. The query is shown below. The issue is that I don't get all the labels if I...
Yes, when I hit "Output" on the SelectLoopReport form. I took out the code, that wasn't needed. This one guy who was helping me a while back suggested using "con" as a variable type because the crosstabs didn't like the temp variables. Looks like I'm not using that anymore.
Ok, so that is...
Hello, I haven't had much time to work on this, but before I start the report I was talking about. I have the rptNSAByPlanWeek and am using John Accelerator in the example. This report is very similar to the Standard Actions by Plan Week report that you helped me with. The main difference is...
Thanks, DHookom; I did find the conditional formatting and fixed the bolding issue.
Enjoy your time off, and if you can look at the subsequent report at your leisure, that would be great.!