Search results

JHB this thing works perfectly! I'm not sure if I would ever come up with a solution like this. I feel like mine would have been much more messier. It's exactly what I asked for and in a way that makes sense to me. Many many thanks. Just tell me if I'm correct on this.... From what I see from...

JHB thanks for the quick reply. Please see the attachments below. I think whats happening is that it's not putting X's on both sides of Revenue and Incentive if they are checked on the form. It's also displaying all items regardless if they have been checked or not. For the results, I only...

The first time I ran the DB, it looked like it worked perfectly. I started analyzing your code, and now I can't replicate the results that I originally achieved. It's like defaulting to showing all records again and doesn't show the ZVIN Revenue side "X" for some records. I redownloaded and it's...

WOW! JHB, you rock my friend! I had totally had given up on this since I wasn't going to have it ready by the end of the month deadline. I just ran through it quickly and looks like it works perfectly. I'm gonna try to study what you did and try to replicate for other uses. Thanks a million. I...

Thanks for the help. I understand that there isn't anything there for designating what check boxes to do. That's why my original question was whether I needed coding or not. I already have a table that designates each condition to the checkbox type. Anyway, the database has all it needs for...

Anyone got any ideas?

Yeah I'm sorry I should have probably given more explanation behind the classification. Please see the attached form picture and the resulting query picture. In the example, I also selected Rolling 12 Month, so it moved the X's over to the "ZRUP" columns. In the report I would not want the...

Any input is appreciated. I'd really like to know if it's possible to accomplish this without coding. If not, I'm going to have to start reading up and I'm 3 or 4 chapters away from it haha.

Hello everyone. First question on the forum and I'm looking forward to learning a bunch. First of all, I'm not sure if this should be in the query sub forum, because I'm having issues with a Query by Form. The results I'm trying to accomplish may even require coding, but I'd like to be aware so...

Hello everyone, my name is Austin and I am a novice Access database builder. (first step is admitting it, right?) I just started getting into Access a month ago after many people at work use it for simple queries. I feel like there are a million uses seeing how I build business case models using...