modify table functions

[Mike Bubyn]

Hello All,

I have little to no Access experience and I have been asked to modify a
report. Good luk to all of us!!

The report shows the status for all staff's training completions. Currently
we have the output to "Have" (if they have completed the training) and "need"
(if the training is expired or will expire in the next 30 days).

I need to modify two things:

1. Move 30 day expiry date to 90 days
2. change the “need†output to show the actual expiry date

I believe I have isolated the two functions I just need help with their
changes.

1. CourseValid: (([DateRetrain]>Now()) Or (([Course].[NumRetrain] Is Null)
Or ([Course].[NumRetrain]=0)) Or ((([Course].[NumRetrain]>0) Is Not Null) And
(DateDiff("m",[ClsHistory].[DateClass],Now())<=[Course].[NumRetrain]))) And
([ClsHistory].[Status]='Scheduled')

2. For the second one; (please note that the date I want is from another
table). “need†to show date

Status:IIf([ValidCoursesByEmployee].[CourseValid],"Have",IIf(([EmployeeRequiredCourses].[Title] Is Not Null),"Need",""))

I would appreciate any help with this.
Cheers,
Mike.

 

[KARL DEWEY]

Need a little more information. Open the query used for the report in design
view, click on VIEW - SQL View, highlight all, copy, and paste in a post.