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.

Question

Engineering

Whitney

17 December, 10:43

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.

+2

Answers (1)

Know the Answer?

Jolee · Answer 1

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.