If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep the current date in a field
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. |
#2
|
|||
|
|||
Keep the current date in a field
Use a form to show current date in an unbound text box.
-- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#3
|
|||
|
|||
Keep the current date in a field
Ok, how do I do that?
"KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#4
|
|||
|
|||
Keep the current date in a field
Open form in design view and set the source for the unbound text box =Date()
and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#5
|
|||
|
|||
Keep the current date in a field
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. "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#6
|
|||
|
|||
Keep the current date in a field
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" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#7
|
|||
|
|||
Keep the current date in a field
You can not. That is why you use a form to always show the current date.
Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#8
|
|||
|
|||
Keep the current date in a field
Bummer.......but thanks for all your help
"KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#9
|
|||
|
|||
Keep the current date in a field
Maybe if you explain your process a little more someone might suggest an
alternative solution. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Bummer.......but thanks for all your help "KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
#10
|
|||
|
|||
Keep the current date in a field
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() "KARL DEWEY" wrote: Maybe if you explain your process a little more someone might suggest an alternative solution. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Bummer.......but thanks for all your help "KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|