I have a 'lookup' table regarding file types which includes a field for a retention schedule. The CkYear field holds a whole number to be used in calculating the year that the file needs to be reviewed for disposal.
I want to add that number (which is different depending on the type of the file opened) to the Year(currentdate).
Example: Date file Opened = 05/16/2002
Discrimination file type with CkYear = 6
I want to take the 2002 and add the CkYear whole number - 6 - to it and enter the result in a field in the main table.
I am trying to create a function to accomplish this, but am having trouble incorporating a "where clause" to find the corresponding CkYear number depending on the file type on the current data entry form.
Is this the appropriate approach ?
Thanks for your help.
I want to add that number (which is different depending on the type of the file opened) to the Year(currentdate).
Example: Date file Opened = 05/16/2002
Discrimination file type with CkYear = 6
I want to take the 2002 and add the CkYear whole number - 6 - to it and enter the result in a field in the main table.
I am trying to create a function to accomplish this, but am having trouble incorporating a "where clause" to find the corresponding CkYear number depending on the file type on the current data entry form.
Is this the appropriate approach ?
Thanks for your help.
