Member Avatar for jmw229

Hi Guys,

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.

Some guidance and/or assistance would be greatly appreciated.

Thanks,

Jay

  • 1 Contributor
  • 1 Reply
  • 85 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by jmw229
Member Avatar for jmw229

forgot to provide an example:
For example:

Form:
- The client enters their age and employment status
Client Age
Employment Status
Preferred Location (if any)

The criteria is matched up with the services/programs provided.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.