Question: I need help wth microsoft access I am trying to set the validation rule on the ExpectedGraduation field to accept the values 2018 , 2019

I need help wth microsoft access I am trying to set the validation rule on the ExpectedGraduation field to accept the values 2018, 2019, 2020, or 2021 (in this order) only. If it does not enter those dates then in the Validation Text i will have it pop up that they need to enter the dates of 2018 2019 2020 or 2021. But I tried Between #1/1/2018# And #12/31/2021# but that didnt work I just keep getting the validation text popping up everytime I try and enter the Expected Gradtion Date. I ahve also tried just putting in 2018-2021 and Bteween 2018 and 2021 and Between "2018" and "2021" and also tried Between Year(#1/1/2018#) And Year(#12/31/2021#). I cant figure this out I just need help with the validation rule not the validation text that is easy.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

PLEASE LISTEN CAREFULLY. I DO NOT NEED STEPS 1-7. I NEED STEPS 8-18. PLEASE PROVIDE SCREENSHOTS AND EXPLAIN. DO STEPS 15, 16, 17. OR MORE IF YOU LOVE ME. thats ONLY 4 STEPS... CHEGG ALLOWS 4...

I need step by step instructions to complete this... EX16_AC_COMP_GRADER_CAP_AS - Student Loans Project Description: In this project, you will add fields to a table and set data validation rules. You...

PLEASE LISTEN CAREFULLY. I DO NOT NEED STEPS 1-7. I NEED STEPS 8-18. PLEASE PROVIDE SCREENSHOTS AND EXPLAIN. DO STEPS 8, 9. 10. 11. OR MORE IF YOU LOVE ME....

Access Data Base Table - Set the validation rule on the ExpectedGraduation field to accept the values 2018, 2019, 2020, or 2021 (in this order) only. Set the validation text to read Please enter...

Access Data Base Table - Set the validation rule on the ExpectedGraduation field to accept the values 2018, 2019, 2020, or 2021 (in this order) only.

1.Describe the competitive position of Best Buy relative to its main competitors. 2.What is Best Buy's business-level strategy? What are its main value and/or cost drivers? 3.Is Best Buy's strategy...

I need help with how to do a DCF analysis for this Spotify case. Please can you show the explanation of the steps Thank you A. Using the information provided, what should SPs shares be trading at on...

the forces controlling its profitability (e.g., Five Forces analysis). Is Best Buy positioned for long-term profitability? Best Buy Co., Inc. By 2017, the value of Best Buy's stock climbed over 200...

Read the case study and answer asap: How does the social mission affect the development of the new venture and its access to resources? Hola, Bandida: Launching A Beverage Brand with Purpose *n...

Learning Outcomes define the valuation and reporting of current liabilities, estimated liabilities, and other contingencies. interpret company solvency through selection and application of...

Mark Remus has the following data on his passive income the current year. Interest income from long-term peso bank deposits Interest income from long-term Foreign Currency Deposit Unit (FCDU)...

In a steam heating system, air is heated by being passed over some tubes through which steam flows steadily. Steam enters the heat exchanger at 30 psia and 400F at a rate of 15 lbm/min and leaves at...

ine call and put options on King Books Incorporated are available with exercise prices of $ 3 0 , $ 3 5 , and $ 4 0 . Among the different exercise ices, the call option with the q , exercise price...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. As the new HR Director of a company in the behavioral health industry, you have the responsibility to develop a performance management system. You need to present a business case to senior...

2. Suppose you are a supervisor. What errors might you make when preparing the performance appraisal on a clerical employee? How might you avoid those errors?

3. Ratings, rankings, and other approaches used to assess employees job performance are always subject to discussion and debate. Managers need to understand the current applications associated with...