How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have 3 tables within access 2013, 2 of the lists have

Customer Question

Hi,I have 3 tables within access 2013, 2 of the lists have unique values where the 3rd list can have multiple criteria -List 1 - Applications
G-Star
S-Star
Raw-Star
Man-Star
H-StarList 2 - Employees
00000001 - Bevan
00000002 - Craig
00000003 - Mike
00000004 - Daphne
00000005 - Kate
00000006 - Lance
00000007 - Jane
00000008 - RobertList 3 - Application Specialist
G-Star = Bevan; Craig; Mike
S-Star = Daphne; Kate; Mike; Craig
Raw-Star = Bevan; Craig; Robert
Man-Star = Lance; Jane; Bevan
H-Star = Robert; Jane; BevanCan you please help with a query within Access that when the application from List 1, provides a drop down choice of Application Specialist from List 3 in a form?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jason Carlamere replied 1 year ago.

Hello - Thank you for posting your question. My name is ***** ***** I will be helping you. So to be sure that I am clear on your question, you would like a query that lists all the names for a given value from List 1 ?