Ask Question
19 August, 18:46

Add a calculated field named AccountTime that calculates the number of days each client's accounts have been open. Assume today's date is 12/31/2017. Recall dates must be enclosed in # to denote to Access it is a date. Explain how to enter this in Access.

+3
Answers (1)
  1. 19 August, 21:42
    0
    The following steps should be followed to create the calculated field:

    1. Enter AccountTime: (The AccountTime must be enclosed in #). #12/31/2017#-OpenDate in the first empty field.

    2. Right-click the field then click properties. This will allow you format the selected field.

    3. Rght-click the query tab and click Save. This will allow you save the query

    4. Lastly, Close the query.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Add a calculated field named AccountTime that calculates the number of days each client's accounts have been open. Assume today's date is ...” in 📙 Engineering if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers