Recent content by benny

Excellent, thanks for the help

The idea above seems to work. The Db wont have more than 1,000 employees in it at one time so it should not become sluggish even with it being split. Thanks for the help Brian.

I have one table that has all the training course titles in a table simply called TrainingCourseList the Employee Training table uses a drop down pulling from this table for the titles to ensure continuity. If there is a way that it will allow me to do it that would be great. Also i was...

It is close :) I have tried the unmatched query wizard and while it will return the unmatched SAP data i cannot control the course title. So my worry is once all personnel in the db have taken some kind of course there will no longer be any unmatched SAP so i still wont be able to have a roster...

In the criteria row of the date field you want to do this to put the following: Between [write anything you want here] and [anything you want] Inside the brackets, whatever you write will appear on the pop up window so something like [Beginning Date] or [Ending Date] etc will probably be...

Sorry: The fields i need to retrieve for the training pending are .... SAP LastName FirstName Department Onsite Offsite Thanks

If i were to guess i would say this is probably something easy for the people here however ...... I have created a Db to track training within my company. I created several tables as to not make redundant records. The problem is i can easily pull out training that has been completed but also...