Access assignment question

Copper Contributor

Hi all,


I'm currently working of a school assignment in access and am a bit confused.  One of the steps is to "add a criterion for the "advisor field" that allows the user to enter a different advisor each time a query is run.  I know where the criterion field is but we have 3 different fields for the advisor.  We have advisor #, advisor last name, and advisor first name.  Which field would I use for the criterion and what exactly am I supposed to enter?  

1 Reply



You could concatenate the first/last name and hide the advisor # then search the table for the record that matches the advisor #