Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-12-2019, 11:47 AM   #1
Newly Registered User
Join Date: Jul 2019
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
goophibama is on a distinguished road
Multi criteria query

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.

Access Capture.GIF

goophibama is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA and Query criteria from Multi-Value lists KNutta Queries 8 07-29-2015 11:29 PM
Multi criteria combo query problem compton clerk Queries 5 08-03-2014 11:55 AM
Ignoring null criteria in a multi-criteria query… Nano Queries 16 10-29-2013 12:01 PM
Multi Select ListBox criteria in query oihjk Forms 1 04-01-2003 03:58 PM
using multi-select on a listbox to set query criteria criteria kom73 Forms 1 10-10-2001 03:45 AM

All times are GMT -8. The time now is 02:47 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World