Home

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
Mczar240
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?  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies