Search results

One of the issues was that the report was created after I had already had 12 weeks of data. It wasn't until I cleared out all the test data and started testing with new data that I found the original error. The report wouldn't run unless it had all the data. I did the DLookups for the dates...

I do thank you for taking the time to help. It gets a little frustrating, especially since I don't have a great deal of time to put toward this. I am doing this for a friend and just want to get this working for them. That being said I have take the query you have made and put it into my...

If I were to seek paid support, how would I do that? I want to take the faster/best route as you recommended.

Hello, I have not had much time to put into this project and was wondering if there was a way we could Zoom or Teams meet to help resolve this issue I am having. I don't want anyone to do the work for me; I want to understand what is happening and learn better with a hands-on approach. If you...

Yes, I have many reports with too many rows to do as a crosstab. It seems to be an issue with Access. I am self-taught and struggle with this, but I feel I've done well. You should have seen my first version of this. The tables were a mess. Is there any place or person that could do a Zoom...

That looks great. It is almost what I need. Now, I just need to understand it and apply it. I have another report that does the same thing, and I need to apply this fix to it. The only thing is that I am not pulling the exact data; I am just acknowledging that there was an action for that week...

Hey there. I remember you from a while back. I was doing some testing and realized that I can't access this report without data for the entire Loop (12 weeks). I am posting screenshots of the crosstab query result, the error I get when running the report, and a screenshot of a report that ran...

Hello, I have a report that uses a crosstab query for 12 weeks. I would like to monitor the data even after a few weeks, but I get an error when running it without the data for the full 12 weeks. When I run the query separately, it works fine, but the report is set up for all 12 weeks. Is...

Another option would be to add the values from each field in the subreports to get a total in another subreport. Do you have any ideas on how I could do that? I tried adding the fields together, but I got a type error. I tried this...

I'm not sure that would work because sometimes the value in the field is blank, and other times it's 1, and other times it's X. If anyone else has any input, it would be greatly appreciated.

I can send the database. You have to open the MainMenu form, use Ann Smith, and hit Reports. It will default to week 12. Just hit Output. The report will pop up. From there, you can go into the design view and trace through the logic. My goal is to do some kind of cross-tab, but I need the...

Hello, I have run into a snag with my reporting. I have a complicated report that I can't seem to get to work the way I would like. I have a Daily Progress by Standard Action report that is made out of several subreports using the query qlkpStandardActionPoints query to pull data for each...

Ok, I got it. I already had them as a group, I didn't realize they had a value of 1, 2, 3. Thanks! Now I need to figure out how to save the report as a pdf to my computer.

Hi guys, I have three radio buttons (Screen, Print, PDF) that I am using to view, print, and save my reports. I am using nested if statements that look like this. If Me.txtReportName = "Week at a Glance" Then If Me.rdbScreen.Value = True Then DoCmd.OpenReport "rptWeekAtAGlance"...

I Thanks a bunch!

Nevermind, I was using the "Immediate Window" without using the ?

DCount("[ActionIDFK]", "tblActionsPerWeeklyPlan", "[WeeklyPlanIDFK] = " & Me.txtWeeklyPlanID & " AND [ActionIncluded] = True AND [ActionIDFK] = 3") Now I'm getting an = sign is expected

Hi guys, I'm a little rusty on the syntax for multiple criteria. I need the number of records that have the Plan ID of "Me.txtWeeklyPlanID" with the ActionIncluded = True and the ActionIDFK = 3 This is the code I use, but I get an "Expected list separator" error. DCount("[ActionIDFK]"...