Search results

I'd like to thank you guys for the impetus to take a shot and learn some VBA. I got it doing what I want it to do. Of course there's going to be some cleaning and quality of life stuff (like if no field is selected) that need to be cleaned up. but I'm over the moon on this one right now...

Discretion being the better part of valor, I don't think this is possible with my current skill set. I have exactly zero experience in VBA. I would like to thank you again though for your assistance.

You are correct in your assessment, and having to dive in to code is exactly what I was afraid I'd have to do. I'm not a coder by any stretch of the imagination. Thank you though for your assistance! Back to the books to learn more about querydef.

Thank you both for the prompt response! theDBguy: My end goal in all of this is to try to automate these queries a little bit more. I have a few more queries like this I use fairly regularly where I only need to change one field in the query to get a different count. Being able to change the...

I have only scratched the surface of using Access so I may be in way over my head here. I have a List Box on a form that I want to use to select the field for a query. The Row Source is the table the query is being ran on, and the Row Source Type is set to Field List. I guess I am just missing...