I was hoping someone could help me with an issue I'm having with a query and hopefully, I can do a decent job of explaining what I'm wanting.
I have a database of business licenses that I am building and I need a query that will return an activity type but only for businesses that are licensed this year. So for instance, you might want to check to get a list of bowling alleys that have an active license, but the user can put in a partial string and it will find matches, but again, only for those with a date falling within this year. I've tried every combination that I can think of, but I can't get this to work. Does anyone have any suggestions? It's been about 15 years since I've used Access, so what I used to know (which admittedly wasn't much) is pretty much gone and I am having to self-teach from scratch. Thanks in advance, this one has been driving me crazy.