Search results

I am trying all the suggestions with no success. I am resetting my computer. It doesn't make sense that it works on my work computer and not my personal one. I'll let you know. So, if I do get this to work, my next question is to ask why there is a W0. It doesn't seem very clear. I tried...

Thanks for that information. I did the scans and ran a malware scan; it got a few things, but nothing major. It's still happening every time I go to access that query. I'm perplexed. My next option is to complete a Windows installation, reinstall 365, and see what happens. It is troubling...

So I did a complete reinstall of 365, and as I said, it worked for the first time. I could see the query, but the next time I tried, it crashed. I looked in the Event Viewer, and this is what was found. Faulting application name: MSACCESS.EXE, version: 16.0.18324.20168, time stamp: 0x677829a1...

Something is messed up with my Access application. I pulled up this program on my work computer, and it's working. It still needs some tweaks, but it crashes when I open the query on my personal computer. I uninstalled and reinstalled MS 365 and got into the query once, but after that, it...

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"...