Hi I have searched and have not found and answer.
I have a loan database and need to calculate a Due date for return.
The catch is that each item has a max days out number that the date is calculated on.
I have tried an unbound text box on the form with the following in it's control
=[loan date]+[max days out]
but I get #NAME in the box.
I'm thinking I should use DATEADD but it is not a stable number of dates it flucuates with the items max number of days out.
Any Suggestions
I have a loan database and need to calculate a Due date for return.
The catch is that each item has a max days out number that the date is calculated on.
I have tried an unbound text box on the form with the following in it's control
=[loan date]+[max days out]
but I get #NAME in the box.
I'm thinking I should use DATEADD but it is not a stable number of dates it flucuates with the items max number of days out.
Any Suggestions