Hi Guys,
Thank for allowing me on the forum.
I am just a new user in access. It is silly, but I never used it really much.
I was hoping to find some experienced forum members here that could help me further.
What I try to do is very simple. Just i don't know the best road to get there.
situation:
I have created a table and a form. Mainly it is a database
to organise my job applications a bit. Mainly I just took the template for contacts that access 2016 offers
and I modified it to my needs. Also I was forced to start understanding the basic idea of how access works and this is only good.
what I did: I have a table and a form with fields. (Note here: I use the 'DATE' option in all field properties in the table where a Date is stored)
I have a 'StartDate' field that has the date on which I've sent the job application to a certain contact person.
Further, I have a 'TotalDays' field that is meant to express the total of (days/weeks/months) an application
is running. The idea was to be able to filter quickly in the table to collect the applications that need attention.
ok. that's the basic idea.
My question:
i need to do a very simple calculation. And I already found some possibilities on the net.
But none of them gives all steps to take for the beginning access user.
I tried by experimenting, but I am not getting there.
I want to calculate the running time by a formula like: (Current timestamp) - (StartDate) = (TotalDays)
where (and this is the part where I keep in the orbit of a satellite around the core of Access)
the TotalDays result of the formula is stored in the TotalDays field in the table for all records.
So, to be clear, I am not looking for a SQL formula where the result is only displayed in the form field only.
I looked trough forum idea's in visual basic, I looked in people writing about macro's, I looked into SQL queries,
all pointing is a certain syntax and a direction, but I can't find an answer for my needs.
All of those solutions assume knowledge about the access application in general.
That's where i don't see the whole.
Is a visual basic approach, a macro, or a query needed here to get this very simple job done?
If I would find a solution, there is 1 more thing I like to program as an addon:
2 extra fields would be required: 'CloseDate'. and 'EndDays'
Than a boolean would be required ,with something like this:
If (CloseDate <> empty or null)
{ 1.copy value Totaldays to the EndDays field in the table for all records.
2. reset the TotalDays field for all records with a CloseDate to null }
In fact this last part is not essential needed, but it is elegant.
These are the very humble demands I need. And I feel silly not to be able to sort it out.
Can Anyone help this poor Access starter?
Thanks for any help in advantage.
Thank for allowing me on the forum.
I am just a new user in access. It is silly, but I never used it really much.
I was hoping to find some experienced forum members here that could help me further.
What I try to do is very simple. Just i don't know the best road to get there.
situation:
I have created a table and a form. Mainly it is a database
to organise my job applications a bit. Mainly I just took the template for contacts that access 2016 offers
and I modified it to my needs. Also I was forced to start understanding the basic idea of how access works and this is only good.
what I did: I have a table and a form with fields. (Note here: I use the 'DATE' option in all field properties in the table where a Date is stored)
I have a 'StartDate' field that has the date on which I've sent the job application to a certain contact person.
Further, I have a 'TotalDays' field that is meant to express the total of (days/weeks/months) an application
is running. The idea was to be able to filter quickly in the table to collect the applications that need attention.
ok. that's the basic idea.
My question:
i need to do a very simple calculation. And I already found some possibilities on the net.
But none of them gives all steps to take for the beginning access user.
I tried by experimenting, but I am not getting there.
I want to calculate the running time by a formula like: (Current timestamp) - (StartDate) = (TotalDays)
where (and this is the part where I keep in the orbit of a satellite around the core of Access)
the TotalDays result of the formula is stored in the TotalDays field in the table for all records.
So, to be clear, I am not looking for a SQL formula where the result is only displayed in the form field only.
I looked trough forum idea's in visual basic, I looked in people writing about macro's, I looked into SQL queries,
all pointing is a certain syntax and a direction, but I can't find an answer for my needs.
All of those solutions assume knowledge about the access application in general.
That's where i don't see the whole.
Is a visual basic approach, a macro, or a query needed here to get this very simple job done?
If I would find a solution, there is 1 more thing I like to program as an addon:
2 extra fields would be required: 'CloseDate'. and 'EndDays'
Than a boolean would be required ,with something like this:
If (CloseDate <> empty or null)
{ 1.copy value Totaldays to the EndDays field in the table for all records.
2. reset the TotalDays field for all records with a CloseDate to null }
In fact this last part is not essential needed, but it is elegant.
These are the very humble demands I need. And I feel silly not to be able to sort it out.
Can Anyone help this poor Access starter?
Thanks for any help in advantage.
Last edited: