T
Tbird2340
I have an Access table that has a field named "DateSubmitted".. The default
value of this field is Now() which will insert the date / time when a new
record is created.
I want to know how old each record is so I have a query with the following
field:
HowOld: Now()-[DateSubmitted]
This just gives me the results in decimal format.
IE: 0.08 or 6.41, etc..
I want to format this as X day(s), X hour(s), X minute(s), X seconds.
How do I do this?
Thanks in advance!
value of this field is Now() which will insert the date / time when a new
record is created.
I want to know how old each record is so I have a query with the following
field:
HowOld: Now()-[DateSubmitted]
This just gives me the results in decimal format.
IE: 0.08 or 6.41, etc..
I want to format this as X day(s), X hour(s), X minute(s), X seconds.
How do I do this?
Thanks in advance!