Access assignment question

%3CLINGO-SUB%20id%3D%22lingo-sub-1011298%22%20slang%3D%22en-US%22%3EAccess%20assignment%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1011298%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20currently%20working%20of%20a%20school%20assignment%20in%20access%20and%20am%20a%20bit%20confused.%26nbsp%3B%20One%20of%20the%20steps%20is%20to%20%22add%20a%20criterion%20for%20the%20%22advisor%20field%22%20that%20allows%20the%20user%20to%20enter%20a%20different%20advisor%20each%20time%20a%20query%20is%20run.%26nbsp%3B%20I%20know%20where%20the%20criterion%20field%20is%20but%20we%20have%203%20different%20fields%20for%20the%20advisor.%26nbsp%3B%20We%20have%20advisor%20%23%2C%20advisor%20last%20name%2C%20and%20advisor%20first%20name.%26nbsp%3B%20Which%20field%20would%20I%20use%20for%20the%20criterion%20and%20what%20exactly%20am%20I%20supposed%20to%20enter%3F%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1011298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065553%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20assignment%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F430472%22%20target%3D%22_blank%22%3E%40Mczar240%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20concatenate%20the%20first%2Flast%20name%20and%20hide%20the%20advisor%20%23%20then%20search%20the%20table%20for%20the%20record%20that%20matches%20the%20advisor%20%23%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@Mczar240 

 

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