Hey all. I am creating a new tool for use at work and I think Access is the best way to go. I'm not a pro at this by any means but my employer is allowing me to try to make this work. I just wanted to post to make sure that you guys agree that Access would be the best way to go for this idea.
I have 5 variables. When using the tool, the user will select v1 from a drop down. Based on what is selected, the system should assign v2. The user will also select either v3 or v4 from a second drop down. Using v2 and either v3 or v4 (whichever the user selected), the system should produce v5, the final result.
It's hard to put a flow chart into words so I hope that made sense.
I'm taking this opportunity to learn some Access procedures as I go. I have basic exposure to the software but nothing extensive. Any advice would be appreciated but the point of this thread is just to confirm that Access can in fact achieve the goal of my project. Thanks all.