Search results

Mr. B, your solution works great...thank you. :)

There is likely a simle answer to this but I cannot seem to find it. I use a pop-up form to bring up a report after choosing a name from a drop-down list and clicking "ok". I would like the form to auto-close after it brings up the report, how do I accomplish this?

@student, okay got the tables set p and working properly but now I have a new problem, it is calculation due dates for really old data as well. How to express "no older than three years from today"?

Yes, I understand now..thanks, I'll give that a try.

The dates duplicate because there are several employees that have attended the same class of the past five years, multiply that by 100+ courses and that will give you an idea of what I'm looking at. I'm trying to narrow it down by splitting the table while keeping related information connected...

@student: I was thinking the same thing. In fact, I'm working on that now, just having a tough time because of the amount of historical data because it causes tons of duplicate date in the tables.

Thanks for the reply, I was able to figure it out shortly after I posted the question. The course ID field is unique and identifies which courses are good for one, two, or three years. I had to use an "iif" statement...

I am new to this forum and reletively new to Access as well, please by patient. I am attempting to display a field called "DueDates" based off of data located in another Field called "CourseCompletionDates", I know how to advance every record by a determined amount but what I am trying to due...