Nov 15 2019 07:42 AM
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?
Dec 13 2019 09:30 AM
You could concatenate the first/last name and hide the advisor # then search the table for the record that matches the advisor #