Number of days issue

[posfog]

Hi there
I wondered if some could help me as new to access and having the following issue

I have a database where there are two dates that need to bee filled in

1 is called open for when a issue is reported and the 2nd on is called closed for when the issue has been resloved.

Now i also have a field called days open where i want to beable to show the number of days a issue was open for ( number of days between open and closed) or if the issue is still open for it to work out the number of days from it being open and the current date.

Is this possible at all?

Regards
P

 

[posfog]

Hi Joe4
sorry for delay in getting back to you.

Anyway want to say a big thanks for information, as it now works a treat!

Thanks!

P

Create your query to show all the fields in your data, as well as any calculated fields that you want.
Then, go into your Form, click on Properties, and change Record Source property from the Table to the Query you just created.
It will then show you all the fields in your query that are Available, and you can add the Calculated fields to the Form.

 

[Joe4]

Excellent! Glad to hear it!
You are welcome.