I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access.
In the form, the user enters their information as well as checks the applicable check boxes. When they have completed the form, they click the 'Generate Match Report' button and it matches the programs the user is eligible for based on what the user has input. I've looked at numerous union query examples, however, I haven't been able to figure out exactly how to do this.
- The client enters their age and employment status
Preferred Location (if any)
The criteria is matched up with the services/programs provided.
Some guidance and/or assistance would be greatly appreciated.