Keep the current date in a field

[Shannon]

I need to have a constant calculation of the days on market (DOM) for real
estate in a table as well as on a report. I can get the table to show the
current date for new entries. But it will not stay "current". EX: enter a
new listing today, the day automatically shows as the 6th. But tomorrow,
instead of showing as the 7th, it still shows as the 6th. I need a column
that will update to the current date every day.

 

[KARL DEWEY]

Use a form to show current date in an unbound text box.

 

[Shannon]

Ok, how do I do that?

Use a form to show current date in an unbound text box.

 

[KARL DEWEY]

Open form in design view and set the source for the unbound text box =Date()
and that will do it.

 

[Shannon]

OK I think I got it, we'll know tomorrow when the date does on doesn't
change. One thing; in my table I have the validation rule and the default
value for my "Current Date" field set to Date(). Is that ok? Thanks for you
help, hopefully I got it right.

 

[Shannon]

Ok how do I link the form and my current database table so that the results
appear in the table as fell as on the form

 

[KARL DEWEY]

You can not. That is why you use a form to always show the current date.

Maybe Excel is what you need.

 

[Shannon]

Bummer.......but thanks for all your help

You can not. That is why you use a form to always show the current date.

Maybe Excel is what you need.

 

[KARL DEWEY]

Maybe if you explain your process a little more someone might suggest an
alternative solution.

 

[Barry A&P]

Shannon

if you like the data listed in a table type form, how about adding a query
with all the fields of your table. open the query in design view and in an
available "field" box put an expression like Days on Market:
[Your_Realestate_table]![Date_listed?]-Date()