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 12/31/2017.Recall dates must be enclosed in # to denote to Access it is a date.Explain how to enter this in Access.

Answer 1

Answer:

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.