Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    tb199 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    10
    Quote Originally Posted by tb199 View Post
    Also basically themes and skills arent related!
    Anyone? I really need the help.

  2. #17
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    I gave you a query that works. You just have to add criteria to it to give you the results you want, for instance if you're looking for a particular theme and skill you can come up with a list of people who satisfy the items selected by the user so what exactly is question?

  3. #18
    tb199 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2014
    Posts
    10
    Quote Originally Posted by rpeare View Post
    I gave you a query that works. You just have to add criteria to it to give you the results you want, for instance if you're looking for a particular theme and skill you can come up with a list of people who satisfy the items selected by the user so what exactly is question?
    Please can you put them together for me? Im a total novice!

    I want to be able to search for a skill and everyone that holds those skills is displayed: The results need to display - Title, First Name, Surname, Tel, Email, Location and the skill.

    I also need a query which is the same as above but is skill within a theme and another which is skill within a location.

    Please help me.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multi Search Form in Access 2010 Issues
    By AccessJunky in forum Access
    Replies: 4
    Last Post: 08-23-2019, 11:02 PM
  2. Access 2010 - Multiple Rows in Form w/ checkboxes
    By stevedefazio in forum Forms
    Replies: 4
    Last Post: 09-17-2013, 05:05 PM
  3. Creating a search box in Access 2010 form
    By d4jones in forum Forms
    Replies: 3
    Last Post: 07-18-2012, 02:53 PM
  4. Replies: 12
    Last Post: 03-22-2012, 02:48 AM
  5. Replies: 3
    Last Post: 01-17-2012, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums