Forum Discussion

Mczar240's avatar
Mczar240
Copper Contributor
Nov 15, 2019

Access assignment question

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?  

access
office 365
  • Jesse2315's avatar
    Jesse2315
    Copper Contributor
    Dec 13, 2019

    Mczar240 

     

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

Share

Resources