Ask Question
10 January, 16:51

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.

+4
Answers (1)
  1. 10 January, 17:21
    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?
Find 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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers